Re: [PATCH] Null Terminated Character Problem

Example:

2006-04-28 16:09:30 [3130] [7] DEBUG:      data: 74 65 78 74 3a 20 00
                            text:
.

2006-05-13 01:42:10 [6892] [3] SQLBOXDEBUG: Query debug: INSERT INTO
sent_sms (sql_id, momt, sender, receiver, udhdata, m
sgdata, time, smsc_id, service, account, sms_type, mclass, mwi, coding,
compress, validity, deferred, dlr_mask, dlr
_url, pid, alt_dcs, rpi, charset, boxc_id, binfo) VALUES (NULL, 'MO',
'83252', '+447766906376', NULL, 'id:566357235
 sub:001 dlvrd:001 submit date:0604301954 done date:0604301954 stat:ACKED
err:003 text:
2006-05-13 01:42:10 [6892] [3] ERROR: MYSQL: You have an error in your SQL
syntax; check the manual that correspond
s to your MySQL server version for the right syntax to use near
''id:566357235 sub:001 dlvrd:001 submit date:060430
1954 done date:0604301954 stat' at line 1

Regards

On 5/13/06, Mi Reflejo <[email protected]> wrote:
> * gw/smsc/smsc_smpp.c
> -Remove Null Terminated Character from Delivery Reports
> Some providers like MBLOX send 00 hex character in delivery reports.
>
> if handle_dlr does not do any conversion to msgdata when a Delivery
> Reports comes with 00 hex character the cstr representation of
> msgdata will put an additional \0 to the end - and when this string is
> concatenated to another (like when sqlbox does an INSERT statement)
> the final string has an \0 in the middle. This may affect a
> lot of operations with the final string.
>
>
>