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 >>>>>>> >>>>>> >>>>>> >>>>> >>>> >>> >>
