Great I installed it and it works fine. Good job Rene ;) Tks
Rene Kluwen wrote: > > Your solution exists already. > Update sqlbox to latest svn (later than 2010-08-02). > The quote bug is solved in that version. > > == Rene > > > -----Original Message----- > From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf > Of adams0 > Sent: Tuesday, 10 August, 2010 16:56 > To: users@kannel.org > Subject: sqlbox problem with utf-8 coding > > > Hello All, > I am using kannel-1.4.3 with sqlbox-0.7.2. > Sqlbox works fine except that I encounter a coding pb when sending char > like > ', > I receive /' on my cell phone. > I know this is known pb and looked for solutions online, but no success. > > ex: I send an http request with text = d'utilesssql. > If I check my logs I have: > > access_smsbox_server.log: > 2010-08-09 15:09:22 send-SMS request added - sender:tester:parameter > 127.0.0.1 > target:xxxx request: 'd'utilesssql' > > sqlbox: > | sql_id | momt | sender | receiver | udhdata | msgdata | time > > | smsc_id | service | account | id | sms_type | mclass | mwi | coding > | > compress | validity | deferred | dlr_mask | dlr_url | pid | alt_dcs | rpi > | > charset | boxc_id | binfo | > +---------+------+-----------+-------------+---------+--------------+------- > -----+-----------+---------+---------+------+----------+--------+------+---- > ----+----------+----------+----------+----------+---------+------+---------+ > ------+---------+---------+-------+ > | 3422777 | MT | parameter | xxxxxx | NULL | d'utilesssql | > 1281359362 > | > group_all | tester | NULL | NULL | 2 | NULL | NULL | 0 | > > NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | > NULL > | NULL | NULL | > > access_server.log: > 2010-08-09 15:59:11 Sent SMS [SMSC:xx] [SVC:tester] [ACT:] [BINF:] [FID:] > [META:] [from:parameter] [to:xxx] [flags:-1:0:-1:-1:-1] > [msg:14:d./'utilesssql] > [udh:0:] > > > I 've set everything in utf-8 from kannel (.conf files) to mysql and linux > (env). Magic quotes on mysql are off too. > > Please help meon that subject. > I think the solution would go through php or C dev but I am not really a > specialist on these points. > Rgds > Adams > -- > View this message in context: > http://old.nabble.com/sqlbox-problem-with-utf-8-coding-tp29397830p29397830.h > tml > Sent from the Kannel - User mailing list archive at Nabble.com. > > > > > > > -- View this message in context: http://old.nabble.com/sqlbox-problem-with-utf-8-coding-tp29397830p29407044.html Sent from the Kannel - User mailing list archive at Nabble.com.
