Hi, Did you set charset to utf8 and coding 2 ?
J On Fri, Nov 12, 2010 at 10:38 PM, Harbhag Singh Sohal <harbhag.so...@gmail.com> wrote: > I got the latest svn and recompiled and installed sqlbox. But I am > still getting strange characters on my phone while sending sms in > Punjabi. > > On Fri, Nov 12, 2010 at 8:23 PM, James E <jam...@gmail.com> wrote: >> Hi, >> >> If its already on the SVN, I suggest using that. >> >> svn co https://svn.kannel.org/sqlbox/trunk sqlbox >> >> Regards, >> J >> >> On Fri, Nov 12, 2010 at 9:46 PM, Harbhag Singh Sohal >> <harbhag.so...@gmail.com> wrote: >>> >>> Today I used SVN for the first time so can your please tell me how can >>> I update sqlbox to the latest svn. and how can I apply this patch. >>> Thanks for your kind help. >>> >>> On Fri, Nov 12, 2010 at 8:01 PM, Harbhag Singh Sohal >>> <harbhag.so...@gmail.com> wrote: >>> > Thanks for the patch james. >>> > On Fri, Nov 12, 2010 at 7:21 PM, James E <jam...@gmail.com> wrote: >>> >> Hi Harbhag, >>> >> >>> >> I used this patch. Compliments of Stipe. >>> >> >>> >> Regards, >>> >> J >>> >> >>> >> >>> >> >>> >> On Fri, Nov 12, 2010 at 8:36 PM, Harbhag Singh Sohal >>> >> <harbhag.so...@gmail.com> wrote: >>> >>> >>> >>> I have installed kannel using latest svn along with sqlbox and I am >>> >>> still not able to send Unicode SMS via sqlbox. Somebody please help, >>> >>> its very urgent. >>> >>> >>> >>> On Wed, Nov 3, 2010 at 4:32 AM, James E <jam...@gmail.com> wrote: >>> >>> > Hi, >>> >>> > >>> >>> > I have found the answer through Stipe. >>> >>> > >>> >>> > --- >>> >>> > yep, sqlbox truncates the payload for UCS-2 indicated messages. I'm >>> >>> > building >>> >>> > a >>> >>> > patch for this, which I will post to the devel@ mailing list for >>> >>> > review >>> >>> > by >>> >>> > the >>> >>> > others too. This will allows Unicode (UCS-2) support again for sqlbox >>> >>> > (SQL >>> >>> > injections of MT messages). >>> >>> > >>> >>> > Please subscribe to the devel@ mailing list to get further information >>> >>> > about >>> >>> > the >>> >>> > resolution while happening. >>> >>> > -- >>> >>> > The patch is going to be >>> >>> > committed to SVN if there are no objections by the team. >>> >>> > -- >>> >>> > >>> >>> > J >>> >>> > >>> >>> > On Tue, Nov 2, 2010 at 5:45 PM, James E <jam...@gmail.com> wrote: >>> >>> >> >>> >>> >> >>> >>> >> 2010/11/2 James E <jam...@gmail.com> >>> >>> >>> >>> >>> >>> Hi Luis, >>> >>> >>> >>> >>> >>> If you mean the column collation then yes, its set to: >>> >>> >>> utf8_unicode_ci >>> >>> >>> >>> >>> >>> Regards, >>> >>> >>> J >>> >>> >>> >>> >>> >>> 2010/11/2 Luís Tiago Rico <lti...@present-technologies.com> >>> >>> >>>> >>> >>> >>>> Hi, >>> >>> >>>> Have you tried to change the encoding of your database? >>> >>> >>>> Cheers >>> >>> >>>> 2010/11/1 James E <jam...@gmail.com> >>> >>> >>>>> >>> >>> >>>>> Hi, >>> >>> >>>>> >>> >>> >>>>> I am beginning to think there is an issue here (or I am missing a >>> >>> >>>>> minor >>> >>> >>>>> detail). Has anyone been able to send unicode sms with sqlbox? >>> >>> >>>>> >>> >>> >>>>> I have searched online for a solution, and all I can find is >>> >>> >>>>> people >>> >>> >>>>> asking the same question as me.. >>> >>> >>>>> >>> >>> >>>>> Any help would be appreciated. >>> >>> >>>>> >>> >>> >>>>> James >>> >>> >>>>> >>> >>> >>>>> On Sun, Oct 31, 2010 at 6:26 PM, James E <jam...@gmail.com> wrote: >>> >>> >>>>>> >>> >>> >>>>>> Hi >>> >>> >>>>>> >>> >>> >>>>>> I am trying to send unicode messages (Thai, Arabic characters >>> >>> >>>>>> etc) >>> >>> >>>>>> using SQLBOX >>> >>> >>>>>> >>> >>> >>>>>> I set in the mysql table send_sms: >>> >>> >>>>>> >>> >>> >>>>>> coding: 2 >>> >>> >>>>>> charset: utf-8 >>> >>> >>>>>> >>> >>> >>>>>> The tables are all UTF8-Unicode >>> >>> >>>>>> >>> >>> >>>>>> On my phone I get strange characters. >>> >>> >>>>>> >>> >>> >>>>>> However when i use sendsms (smsbox) it works perfect. >>> >>> >>>>>> >>> >>> >>>>>> Can anyone please let me know what I am doing wrong? >>> >>> >>>>>> >>> >>> >>>>>> Regards, >>> >>> >>>>>> James >>> >>> >>>>>> >>> >>> >>>>>> >>> >>> >>>>> >>> >>> >>>> >>> >>> >>>> >>> >>> >>>> >>> >>> >>>> -- >>> >>> >>>> Luís Tiago Rico >>> >>> >>>> >>> >>> >>>> Present Technologies >>> >>> >>>> Rua D. João de Castro, Lote 12 >>> >>> >>>> Urbanização Quinta da Fonte >>> >>> >>>> 3030-384 Coimbra >>> >>> >>>> Portugal >>> >>> >>>> >>> >>> >>> >>> >>> >> >>> >>> > >>> >>> > >>> >>> >>> >>> >>> >>> >>> >>> -- >>> >>> Harbhag Singh Sohal >>> >>> Department of Information Technology >>> >>> Guru Nanak Dev Engineering College, Ludhiana >>> >>> >>> >>> Webpage : http://harbhag.wordpress.com >>> >>> Twitter : http://twitter.com/harbhag >>> >> >>> >> >>> > >>> > >>> > >>> > -- >>> > Harbhag Singh Sohal >>> > Department of Information Technology >>> > Guru Nanak Dev Engineering College, Ludhiana >>> > >>> > Webpage : http://harbhag.wordpress.com >>> > Twitter : http://twitter.com/harbhag >>> > >>> >>> >>> >>> -- >>> Harbhag Singh Sohal >>> Department of Information Technology >>> Guru Nanak Dev Engineering College, Ludhiana >>> >>> Webpage : http://harbhag.wordpress.com >>> Twitter : http://twitter.com/harbhag >> > > > > -- > Harbhag Singh Sohal > Department of Information Technology > Guru Nanak Dev Engineering College, Ludhiana > > Webpage : http://harbhag.wordpress.com > Twitter : http://twitter.com/harbhag >