Hi, - smsbox group add "mo-recode=true". - utf-8 in charset column in send_sms table - mysql uses utf-8 (change the column collation)
Regards, J On Fri, Nov 12, 2010 at 10:59 PM, Harbhag Singh Sohal < [email protected]> wrote: > charset = utf-8 > is it ok ? > > On Fri, Nov 12, 2010 at 9:24 PM, James E <[email protected]> wrote: >> Hi, >> >> Did you set charset to utf8 and coding 2 ? >> >> J >> >> On Fri, Nov 12, 2010 at 10:38 PM, Harbhag Singh Sohal >> <[email protected]> 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 <[email protected]> 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 >>>> <[email protected]> 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 >>>>> <[email protected]> wrote: >>>>> > Thanks for the patch james. >>>>> > On Fri, Nov 12, 2010 at 7:21 PM, James E <[email protected]> wrote: >>>>> >> Hi Harbhag, >>>>> >> >>>>> >> I used this patch. Compliments of Stipe. >>>>> >> >>>>> >> Regards, >>>>> >> J >>>>> >> >>>>> >> >>>>> >> >>>>> >> On Fri, Nov 12, 2010 at 8:36 PM, Harbhag Singh Sohal >>>>> >> <[email protected]> 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 <[email protected]> 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 <[email protected]> wrote: >>>>> >>> >> >>>>> >>> >> >>>>> >>> >> 2010/11/2 James E <[email protected]> >>>>> >>> >>> >>>>> >>> >>> 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 <[email protected]> >>>>> >>> >>>> >>>>> >>> >>>> Hi, >>>>> >>> >>>> Have you tried to change the encoding of your database? >>>>> >>> >>>> Cheers >>>>> >>> >>>> 2010/11/1 James E <[email protected]> >>>>> >>> >>>>> >>>>> >>> >>>>> 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 <[email protected]> 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 >>> >> > > > > -- > Harbhag Singh Sohal > Department of Information Technology > Guru Nanak Dev Engineering College, Ludhiana > > Webpage : http://harbhag.wordpress.com > Twitter : http://twitter.com/harbhag >
