Link to home
Start Free TrialLog in
Avatar of henriqmib
henriqmibFlag for South Africa

asked on

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!
ASKER CERTIFIED SOLUTION
Avatar of Haris V
Haris V
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
3. make sure the characters stored are in "proper readable" format
Avatar of henriqmib

ASKER

Thanks Sirah! The second link was exactly what I needed! I didn't realise it was that simple!