Want to notice that I do not properly explained the latest post,
If I send 2 SMS via sqlbox then DLR comes back only for the last sent SMS.
On 13.08.2013 14:17, dorin wrote:
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 <[email protected]
<mailto:[email protected]>> 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 <[email protected] <mailto:[email protected]>>
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!
