non-unicode character problem

[markthien]

Hi guys,

 

    when user enter non-unicode character like chinese characters and I save it to mysql database which become funny character like 手冢治虫 å¸å¾’剑桥 å. However, when retrieving it and it display correctly on webpage. is there anyway I can display it correctly in the database where actual chinese character is showed?

 

    I need this because my java application will grab data from database and send out the message to user via SMS and when I check my SMS in my cell phone, all the chinese character also the same as the database one instead of the correct one.

 

    I tried to manually change the data in the database by directly enter chinese character and when sent out the message and I check my cell phone, all the chinese character display correctly.

 

    In addition to that, if the chinese character in the database is actual one like 周华建是怎样一首歌 instead of 手冢治虫 å¸å¾’剑桥 å, the webpage display all the chinese character like ?????????

 

appreciate anyone could help me on this.

 

regards,

Mark

[o3d]

you might want to encode (base64) your input text before sending to the database. Whatever the client typed in on the form will have to be displayed to the client at some point. So then decoding the input text should display the same text as entered originally.