Convert symbols to Chinese characters or unicode

Posted on 2008-11-18
Medium Priority
Last Modified: 2012-05-05
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!
Question by:henriqmib
  • 2

Accepted Solution

Haris V earned 2000 total points
ID: 22991893
LVL 54

Expert Comment

by:Ryan Chong
ID: 22991911
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
LVL 54

Expert Comment

by:Ryan Chong
ID: 22991917
3. make sure the characters stored are in "proper readable" format

Author Closing Comment

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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Building a website can seem like a daunting task to the uninitiated but it really only requires knowledge of two basic languages: HTML and CSS.
The first step to building an amazing About page is to figure out what you want the page to say about your company. You then must grab the attention of the reader, boast a bit, tell a story and let others brag about you. With a little bit of thought…
In this tutorial viewers will learn how to embed videos in a webpage using HTML5. Ensure your DOCTYPE declaration is set to HTML5: "<!DOCTYPE html>": Use the <video> tag to insert a video. Define the src as the URL of your video; this is similar to …
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question