Hey all, Thanks to RK and Alvaro, this has worked. Thank you very much. I was checking the actual value in db which is utf-8 scrambled, which should be url-decoded.
MT On Tue, Oct 28, 2014 at 10:14 PM, MOSES KARIUKI <kariuk...@gmail.com> wrote: > 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 >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>>> >>>> >> >