Re: Storing Chinese Characters in Sql Server 2000

From: Rt (Rt_at_discussions.microsoft.com)
Date: 10/27/04 

Date: Wed, 27 Oct 2004 14:19:04 -0700

Thanks for your response.

Currently the problem is with the sql server table. It converts chinese
characters to ???

"Steve Kass" wrote:

> First narrow the problem down to whether it is a web interface issue, a
> display issue a storage issue. Here are some possible steps:
>
> If the column that will hold the Chinese characters is defined as
> nvarchar, ntext, or nchar, and verify that
> you are using Unicode or Chinese fonts in Query Analyzer by making sure
>
> insert into T values (... N'中文'...)
> select * from T
>
> displays Chinese characters and that you have Chinese characters in your
> table.
>
> Next try displaying the row you added with Chinese from the web
> interface. If you see ??, the problem is either a browser display issue
> or a data type issue in the web application (you have a wrong type
> declaration somewhere, for example). See if just changing the character
> encoding for the browser solves the problem.
>
> If you see Chinese in the web page in this case, but you can't insert
> Chinese from the web page, try inserting one of the Chinese characters
> that should show up as something other than ? when converted from wide
> character to ASCII, such as the Chinese exclamation point, (！, hex
> 0xFF01), and see if it appears as ! or ?.
>
> Steve Kass
> Drew University
>
> Rt wrote:
>
> >Hi,
> >We have an web app which needs to store english and chinese characters in
> >Sql Server 2000. Currently, when I try to store Chinese characters, the
> >display changes to ?????.
> >
> >Need urgent help.
> >
> >
>

Relevant Pages

  • Review: The Promise (2006)
    ... Chinese martial art fantasy is an unique genre that is very popular in ... Chinese filmmaker, Kaige Chen, is an improbable mess. ... talent of a slave, Kunlun, the General acquires Kunlun as his ... never allowed enough time to stop and savor the characters or the ...
    (rec.arts.movies.reviews)
  • Re: The origins of writing
    ... > "One major difference between Chinese concepts of language and Western ... > characters are inscriptions on oracle bones, ... Cantonese, they are likewise pronounced jing, if we ignore the tone. ...
    (sci.lang)
  • Re: Word count of minimum vocabulary
    ... >> Nor do I have to map a Japanese Kanji to a word when I read ... tie it up with any words -- whether Chinese words or Japanese ones. ... A logograph can be used ideographically, and an ideograph can be used ... do not the characters represent chinese ...
    (sci.lang)
  • Re: Whats happening in SCS?
    ... mention the British Nazi Party's leading intellectuals. ... There is actually no such language as Chinese, ... This is not necesssarily a barrier, as Chinese characters are mutually ...
    (soc.culture.scottish)
  • Re: Origin of Chinese spoken languages
    ... > the dates for total numbers of characters used is interesting, ... She/He certainly referred some Chinese sources. ... > SJ> You can invent any word in any spoken and written languages. ... > Dyl> New characters have always been coined. ...
    (sci.lang)