Convert symbols to Chinese characters or unicode

Posted on 2008-11-18
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
    LVL 8

    Accepted Solution

    LVL 48

    Expert Comment

    by:Ryan Chong
    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 48

    Expert Comment

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

    Author Closing Comment

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Training Course: Adobe Dreamweaver CC 2015

    Adobe Dreamweaver Creative Cloud is used by web designers and front-end developers and allows you to visualize your site in real-time as you code. This course covers exam objectives for the Adobe Certified Associate (ACA) certification.

    This is a PowerShell web interface I use to manage some task as a network administrator. Clicking an action button on the left frame will display a form in the middle frame to input some data in textboxes, process this data in PowerShell and display…
    It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
    In this tutorial viewers will learn how add a full-size background image to a webpage using CSS3. Create a new HTML document with an internal stylesheet.: In CSS, define the html element to have a background image. Use a high resolution image.: In t…
    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 …

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now