Convert symbols to Chinese characters or unicode

Hi there

I have the values similar to these, 1.Ò»ÑÔÌᣵ¥Ò»µÄ´´ÒâÆÀÅбê×¼ÒѾ­¹ýʱÁË (I hope this isn't an offensive statement when converted as I don't understand the symbols), saved to a SQL2005 database. I want to be able to display them on a webpage or convert them for use in a Word Document. I believe the inputs are Chinese, so they need to be converted to Chinese characters.

Thanks for the help!
Who is Participating?
Ryan ChongCommented:
try check this things:

1. Make sure the field to store unicode characters is either nchar, nvarchar or ntext

2. On your scripting end, output the unicode characters by setting the charset (via programming or set on meta tag) to utf-8
Ryan ChongCommented:
3. make sure the characters stored are in "proper readable" format
henriqmibAuthor Commented:
Thanks Sirah! The second link was exactly what I needed! I didn't realise it was that simple!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.