Hi Rajeev,
Thanks for your assistance. Much appreciated.
This is the scenario. I have Sqlbox connected to Kannel. I am using it to
send messages to an external SMSC by inserting messages directly into the
send_sms table of SQLBOX, which in-turn send out the messages. It is
working OK with English Alphabet characters, but when I insert French
characters to the send_sms table of SQLBOX, using the command (
INSERT INTO send_sms (charset,coding,momt, sender, receiver,dlr_url,
msg_text)
VALUES ('utf-8',2,'MT', '8008' ,'+25463232333', 'http://url', 'test déjà')
) the characters are corrupted and this is what appears.
"Test+d%C3%A9j%C3%A0"
To test if database encoding is working : i tried the command below on a
test table called tbl_outgoing,
INSERT into tbl_outgoing (msg_text) values ( 'test déjà');
it works fine.
Select msg_text from tbl_outgoing ;
result is :
*msg_text *
'test déjà'
Why is SQLBOX's insertion of French characters not working?
Thanks a lot for your assistance. Much appreciated.
Moses
On Mon, Oct 27, 2014 at 6:44 PM, RK Krishnas <r...@krishnasoft.in> wrote:
> 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,msg_text)
>> VALUES ('utf-8',2,'MT', '8008' ,'+25463232333', 'http://url','test
>> déjà')
>>
>> 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
>>>>
>>>
>>>
>>
>
