954,587 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Unicode problem

Hi all, I got some little problem for Unicode:

My Unicode were Chienese world => 你好, 有什么能协助您的吗

When the 1st time i insert it in to database it saved in this form
-> "你 好 , 有 什 么 能 协 助 您 的 吗 " ( every 1234 got ";" at behind)

but when i run update query to update it it display in this
ä½ å¥½, 有什么能å助您的å—?

and the database become 你好, 有什么能协助您的吗

how i "encrypt" it to this format
-> "你 好 , 有 什 么 能 协 助 您 的 吗 "
during update?

Nybuler
Light Poster
26 posts since Nov 2008
Reputation Points: 10
Solved Threads: 0
 

Can you post the code which validates and inserts the content into the database, and the code that retrieves and displays the content to the webpage?

And I assume if the Chinese characters are displaying correctly in the database the tables and fields are using UTF-8 Unicode encoding, and the HTML charset is set to UTF-8??

R.

blocblue
Posting Pro in Training
475 posts since Jan 2008
Reputation Points: 142
Solved Threads: 79
 

WHy do you want to store it as incorrect html-encoded format?

THis means to output it correctly you need to add a ';' to it. Also it takes up a ridiculous amount of space.

diafol
Rhod Gilbert Fan (ardav)
Moderator
7,792 posts since Oct 2006
Reputation Points: 1,170
Solved Threads: 1,080
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You
View similar articles that have also been tagged: