Hi Niko,
I surely agree with you and that's the last I wanted to do. It is not my
style to make branches on the trunk.
But I had no time to spend to investigate what's bothering sqlbox and
doesn't give bb utf-8 data to handle.
I want to check it on the future, but now I can't.
My only need is to insert sms on DB, transmit them with bb and get any
dlr back to DB.
Sincerely yours
Mike Nakos
On 05/05/11 20:28, Nikos Balkanas wrote:
Hi Mike,
I believe i first alerted you to the fact that it is an encoding
problem. But from what you describe, you are doing the wrong thing. It
is not a bb issue, and changing it could create problems with smsbox
and kannel spec. The standard communication between boxes for kannel
is UTF-8 (for non-unicode charsets). If sqlbox doesn't do it, it is in
violation and sqlbox should be patched.
BR,
Nikos
On Thu, May 5, 2011 at 8:13 PM, Mike Nakos <[email protected]
<mailto:[email protected]>> wrote:
Sorry for the mess on mailing list, but the previous mail (mail
with the attachment) was referring the 1st email I sent on Apr 30
2011.
On 05/05/11 20:07, Mike Nakos wrote:
Well, after many hours of digging, I found that sms is transmitted
perfectly if it has length up to 160 characters.
Note that, in kannel.conf on
group = smsc
section I use
alt-charset = "UTF-8"
and on db INSERT also (charset field).
But, as I figured out (smsccon.c - int smscconn_send(SMSCConn
*conn,
Msg *msg)), when SMS has more than 160 characters then it
changes path
and is transmitted data that comes from the below code:
parts = sms_split(msg, NULL, NULL, NULL, NULL, 1,
counter_increase(split_msg_counter)& 0xff, 0xff,
conn->max_sms_octets);
which loses data with greek characters. That's because the
data that
comes from sqlbox (for example for greek letter DELTA [Δ])
isn't utf-8
(which means U+0394 - ce 94) but ASCII value 0x10.
I won't examine why is this comes this way, but to I patched
it for
myself (sms.c) so I have a workaround for it.
In a few words, when program flow comes into
extract_msgdata_part_by_coding() function and sms_msgdata_len()
function, thinks data is utf-8 but it is GSM encoded (Note
that, all
characters that I insert INTO send_sms table are url-encoded ex.
%10%12 etc).
All the trick is done with functions charset_gsm_to_utf8()&
charset_utf8_to_gsm() at the points that have the remark text
// mnakos PATCH 2011-05-04 (concat problem fix)
I have the sms.c file attached. I hope it will by stayed
attached and
save someone's desperate time like I was.
