Hi Rajeev,
When I do this :
INSERT into tbl_outgoing (msg_text) values ( 'test déjà');
it works fine.
but when I do:
INSERT INTO send_sms (charset,coding,momt, sender, receiver,dlr_url)
VALUES ('utf-8',2,'MT', '8008' ,'+25463232333', 'http://url')
this ,"Test+d%C3%A9j%C3%A0", is the value that is inserted in SENT_SMS
table of sql box.
I am doing a direct insert using sql code.
Thanks,
Moses
On Mon, Oct 27, 2014 at 4:17 PM, RK Krishnas <r...@krishnasoft.in> wrote:
> HI,
>
> have you url-enoded the sms text before inserting into sqlbox send_sms
> table ???
>
>
> *Rajeev Krishna*
>
> Operations Manager
> Krishnas Software Technologies
> www.krishnasoft.in
> mobile :+91 888 5815 888
> Sales :+91 888 5813 888
> Support :+91 888 5817 888
>
> On Mon, Oct 27, 2014 at 6:35 PM, MOSES KARIUKI <kariuk...@gmail.com>
> wrote:
>
>> Hi Team,
>>
>> I am trying to send a text / sms that has French Characters (Test déjà)
>> using sqlbox but the text always gets corrupted. I have checked and I can
>> insert the same to my postgres database that has utf-8 encoding.
>>
>> I have also tried setting coding=2 and charset='UTF-8' in send SMS but no
>> luck.
>>
>> Please assist.
>>
>> Thanks,
>> MK
>>
>
>
