ç replaced by Ç and ê replaced by ? is smsc-related. You will notice that if 
you do not have sqlbox in between then you will get the same results.

 

About the different tables: Try to change the msg_data field from text to blob.

 

== Rene

 

From: [email protected] [mailto:[email protected]] On Behalf Of 
Emmanuel CHANSON
Sent: Sunday, 05 June, 2011 13:39
To: users
Subject: Charset encofing problem using sqlbox

 

Hello,

I may ask a question that has maybe already been resolved but I did not find 
the solution.

My architecture:
PHP/Mysql -> smsbox HTTP api -> smsbox -> sqlbox -> bearerbox -> GSM modem

Using smsbox HTTP api I am sending the following message using PHP:

test l'e é ç à @ ê

in PHP/Mysql table Outgoing SMS I have:
test l'e é ç à @ ê

in sqlbox sent_sms table I can see:
test l'e é Ç à @ ?

And I receive on my mobile:
test l'e é Ç à @ ?

So ç replaced by Ç and ê replaced by ?

Any ideas to this problem?

BR

Emmanuel

Attachment: smime.p7s
Description: S/MIME cryptographic signature

Reply via email to