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!