Hi,
Please clearly specify the process.
I'm Confused at tbl_outgoing & send_sms.
where & how are you inserting sms & in to which table.
All sms has to be url encoded before inserting into sqlbox "send_sms" table
for unicode sms coding has to be "2".
*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 7:05 PM, MOSES KARIUKI <kariuk...@gmail.com> wrote:
> 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
>>>
>>
>>
>
