Strange sqlbox/kannel bug(?)

Ciaran Scolard <[email protected]>
Newsgroups gmane.comp.mobile.kannel.devel
Message-ID <520BC9B9A8989749A21E8F0183260C3812535936@SRVINFEXCH00.domain.local>
Hi All,

I've encountered a very strange bug(?) to do with kannel and sqlbox.
I'm wondering if anyone can shed some light on it.

When I insert into send_sms and specify the charset field, things start to go strange.

When I do this.
INSERT INTO send_sms00 (momt, sender, receiver, udhdata, msgdata, smsc_id, sms_type, coding, compress, validity, dlr_mask ) VALUES ('MT', '353872115934', '53535', NULL, 'abcde12345', 'euro', 2, 2,  NULL, 4200, 0 )
Everything works fine.
This is without the charset field.

When I do this:
INSERT INTO euro_send_sms00 (charset, momt, sender, receiver, udhdata, msgdata, smsc_id, sms_type, coding, compress, validity, dlr_mask ) VALUES ('utf-8', 'MT', '353872115934', '53535', NULL, 'charset', 'euro', 2, 2,  NULL, 4200, 0 )
Things go strange.
This is with the charset field.

Using the freetds debug log and wireshark I can see that the SELECT TOP 1 from send_sms is working fine.
But interstingley

1)      the charset field is not honoured. When I specify utf-8 it goes out as UCS-2.

2)      When doing the insert into sent_sms the transaction is being truncated.

This is the command being sent to mssql:
INSERT INTO sent_sms00 (momt, sender, receiver, udhdata, msgdata, xtime, smsc_id, service, account, sms_type, mclass, mwi, coding, compress, validity, deferred, dlr_mask, dlr_url, pid, alt_dcs, rpi, charset, boxc_id, binfo, meta_data, foreign_id) VALUES ('MT', '353872115934', '53535', NULL, '

For comparison purposes here is a successful INSERT into sent_sms generated earlier by not specifying the charset field.
INSERT INTO sent_sms00 (momt, sender, receiver, udhdata, msgdata, xtime, smsc_id, service, account, sms_type, mclass, mwi, coding, compress, validity, deferred, dlr_mask, dlr_url, pid, alt_dcs, rpi, charset, boxc_id, binfo, meta_data, foreign_id) VALUES ('MT', '353872115934', '53535', NULL, 'abcde12345', 0, 'euro', NULL, NULL, 2, 0, 0, 2, 0, 4200, 0, 0, NULL, 0, 0, 0, NULL, NULL, NULL, NULL, '80069')
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.