Thanks Alvaro, I will test and revert.
Thanks, MT On Tue, Oct 28, 2014 at 8:20 PM, Alvaro Cornejo <cornejo.alv...@gmail.com> wrote: > Hi > > urlencode(test déjà) = Test+d%C3%A9j%C3%A0 > > Looks like sqlbox is url-enconding your text somewhere. > > I suppose you are working everything in UTF-8, so it should be safe if you > skip charset info on your insert? i.e. try > > INSERT INTO send_sms (coding,momt, sender, receiver,dlr_url,msg_text) > VALUES (2,'MT', '8008' ,'+25463232333', 'http://url','test déjà') > > or > > INSERT INTO send_sms (momt, sender, receiver,dlr_url,msg_text) > VALUES ('MT', '8008' ,'+25463232333', 'http://url','test déjà') > > or even > > > INSERT INTO send_sms (charset,momt, sender, receiver,dlr_url,msg_text) > VALUES ('utf-8','MT', '8008' ,'+25463232333', 'http://url','test déjà') > > Regards > > Alvaro > > > > |-----------------------------------------------------------------------------------------------------------------| > Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier > celular y Nextel > en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS > y GPRS online > Visitenos en www.perusms.com > > On Tue, Oct 28, 2014 at 11:50 AM, MOSES KARIUKI <kariuk...@gmail.com> > wrote: > >> Hi. The whole database is UTG-8. UTF-8 is the default charset on both >> tables. >> On Oct 28, 2014 4:58 PM, "Alvaro Cornejo" <cornejo.alv...@gmail.com> >> wrote: >> >>> Hi >>> >>> I guess both tables are on the same database; What is the default >>> charset of your tables? are they the same? >>> >>> Regards >>> >>> Alvaro >>> >>> >>> |-----------------------------------------------------------------------------------------------------------------| >>> Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier >>> celular y Nextel >>> en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via >>> SMS y GPRS online >>> Visitenos en www.perusms.com >>> >>> On Tue, Oct 28, 2014 at 1:57 AM, MOSES KARIUKI <kariuk...@gmail.com> >>> wrote: >>> >>>> 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 >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>> >
