Re: Problem with sqlbox and utf8

[dorin]

Thanks a lot! Your solution helps me.

Now I have another problem.
When I send one SMS via sqlbox I receive good DLR from SMSC, but if I 
send 2 SMS via sqlbox (I made 2 inserts in the table). No DLR comes back.
What can be the problem?
Kannel accepts many dlr-url in a time?
For ex.
http://134.0.113.138/dlr.php?smsc=%i&from=%P&to=%p&dlr-mask=%d&smsID=1
http://134.0.113.138/dlr.php?smsc=%i&from=%P&to=%p&dlr-mask=%d&smsID=2
Or maybe there another solution for sending a list of SMS?
On 13.08.2013 12:32, Ali Kashif wrote:
i think in addition to coding=2,
you also need to change the Mysql table charset

ALTER TABLE `send_sms`
CHANGE `msgdata` `msgdata` TEXT CHARACTER SET utf8 COLLATE 
utf8_estonian_ci NULL ,
ROW_FORMAT=DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ;


ALTER TABLE `sent_sms`
CHANGE `msgdata` `msgdata` TEXT CHARACTER SET utf8 COLLATE 
utf8_estonian_ci NULL ,
ROW_FORMAT=DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ;

in above query i have changed only `msgdata` field,

i think batter you also change the following fields as well. these can 
also receive the unicoded data if you are getting messges from SMPP 
(openSMPP)

`sender`
`dlr_url``boxc_id`
`meta_data`

specially the Sender, in case of SMPP




On Tue, Aug 13, 2013 at 9:22 AM, dorin <dorinafte...@mail.ru 
<mailto:dorinafte...@mail.ru>> wrote:

    thanks for your reply spameden, but coding=2 didn't helped me.

    On 12.08.2013 18:55, spameden wrote:
    use &coding=2


    2013/8/12 dorin <dorinafte...@mail.ru <mailto:dorinafte...@mail.ru>>

        Hello!
        Have such trouble, I can't send utf8 data via sqlbox. Every
        time it spoils the data. On sent_sms and cellphone arrives
        question mark. Config file contains:

        .....
        system-type = ""
        alt-charset = ucs-2
        ....

        If needs more information data please tell me.

        Please help me!