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: 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 | xx | 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.