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