In php i just passed the parameter from the addslashes(); function before inserting into Databse and it did work for me.
> From: users-requ...@kannel.org > Subject: users Digest, Vol 98, Issue 24 > To: users@kannel.org > Date: Tue, 28 Oct 2014 07:58:08 +0100 > > Send users mailing list submissions to > users@kannel.org > > To subscribe or unsubscribe via the World Wide Web, visit > http://www.kannel.org/mailman/listinfo/users > or, via email, send a message with subject or body 'help' to > users-requ...@kannel.org > > You can reach the person managing the list at > users-ow...@kannel.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of users digest..." > > > Today's Topics: > > 1. SQLBox UTF-8 Encoding (MOSES KARIUKI) > 2. Re: SQLBox UTF-8 Encoding (RK Krishnas) > 3. Re: SQLBox UTF-8 Encoding (MOSES KARIUKI) > 4. Re: SQLBox UTF-8 Encoding (RK Krishnas) > 5. Re: SQLBox UTF-8 Encoding (MOSES KARIUKI) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Mon, 27 Oct 2014 16:05:24 +0300 > From: MOSES KARIUKI <kariuk...@gmail.com> > To: Kannel Users <users@kannel.org> > Subject: SQLBox UTF-8 Encoding > Message-ID: > <CAMKOmQ5a8vYgGEJZjPTsxTbbX_Y3_Rr42htxMkEo=ct3eqj...@mail.gmail.com> > Content-Type: text/plain; charset="utf-8" > > 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 > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: > <http://www.kannel.org/pipermail/users/attachments/20141027/ffa8cf53/attachment-0001.html> > > ------------------------------ > > Message: 2 > Date: Mon, 27 Oct 2014 18:47:43 +0530 > From: RK Krishnas <r...@krishnasoft.in> > To: MOSES KARIUKI <kariuk...@gmail.com> > Cc: Kannel Users <users@kannel.org> > Subject: Re: SQLBox UTF-8 Encoding > Message-ID: > <cahpgazto4yfmqlpbimd6wbssz6thhqz3c4jgc7yo720tluv...@mail.gmail.com> > Content-Type: text/plain; charset="utf-8" > > 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 > > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: > <http://www.kannel.org/pipermail/users/attachments/20141027/3d5399d8/attachment-0001.html> > > ------------------------------ > > Message: 3 > Date: Mon, 27 Oct 2014 16:35:06 +0300 > From: MOSES KARIUKI <kariuk...@gmail.com> > To: RK Krishnas <r...@krishnasoft.in> > Cc: Kannel Users <users@kannel.org> > Subject: Re: SQLBox UTF-8 Encoding > Message-ID: > <camkomq5hweymd0muy-1f4yb69kvemql3vo6oympeyjt_xou...@mail.gmail.com> > Content-Type: text/plain; charset="utf-8" > > 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 > >> > > > > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: > <http://www.kannel.org/pipermail/users/attachments/20141027/c7beaf62/attachment-0001.html> > > ------------------------------ > > Message: 4 > Date: Mon, 27 Oct 2014 21:14:31 +0530 > From: RK Krishnas <r...@krishnasoft.in> > To: MOSES KARIUKI <kariuk...@gmail.com> > Cc: Kannel Users <users@kannel.org> > Subject: Re: SQLBox UTF-8 Encoding > Message-ID: > <CAHpGazseSUA8ZuNT3J8s_irU2oLTgNYmGP=tnE94KoK=qm=t...@mail.gmail.com> > Content-Type: text/plain; charset="utf-8" > > 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 > >>> > >> > >> > > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: > <http://www.kannel.org/pipermail/users/attachments/20141027/bcc63bf7/attachment-0001.html> > > ------------------------------ > > Message: 5 > Date: Tue, 28 Oct 2014 09:57:45 +0300 > From: MOSES KARIUKI <kariuk...@gmail.com> > To: RK Krishnas <r...@krishnasoft.in> > Cc: Kannel Users <users@kannel.org> > Subject: Re: SQLBox UTF-8 Encoding > Message-ID: > <CAMKOmQ4O-QfgW-qji0MEWjHWTaTM=whxstjzx69a-j6wc8o...@mail.gmail.com> > Content-Type: text/plain; charset="utf-8" > > 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 > >>>> > >>> > >>> > >> > > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: > <http://www.kannel.org/pipermail/users/attachments/20141028/9bd89117/attachment.html> > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > users mailing list > users@kannel.org > http://www.kannel.org/mailman/listinfo/users > > > ------------------------------ > > End of users Digest, Vol 98, Issue 24 > *************************************
