ç 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.
*==> So how can I send and receive these corrects characters ? I tried unicode but same result. When you said smsc-related you you mean GSM modem in my case ? I am using GSM modem to send SMS.* About the different tables: Try to change the msg_data field from text to blob. *==> I changed send_sms/sent_sms sqlbox table msgdata field from text to blob but same result.* Thanks Emmanuel 2011/6/5 Rene Kluwen <[email protected]> > ç 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 >
