Sqlbox url-encodes the content, and url-decodes when reading, so you shouldn't have any encoding issues with it.
Regards, Alex On Thu, May 5, 2011 at 7:41 PM, Mike Nakos <[email protected]> wrote: > 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]> 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. >>> >> >> >> > > >
