non-unicode character problem
Posted: Tue Jul 28, 2009 8:55 pm
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
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