Re: Combination of English and Chinese characters in Microsoft SQLServer 2000

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I ran the query as u suggested and the output for the binary string
shows as 3F for the Chinese characters. If that means there is a
problem in input, how do I go ahead from here?

On Nov 21, 9:17 pm, Erland Sommarskog <esq...@xxxxxxxxxxxxx> wrote:
newsqlserveruser (trupti.puj...@xxxxxxxxx) writes:
We have Microsoft SQL Server 2000 with Service Pack 3a installed. In
one of our databases, we have a table REQ with one of the fields
COMMENT being defined as TEXT. Now, when we try to view the COMMENT
field, it shows us only English characters whereas the Chinese
characters are displayed as ?.
Is it possible to store both English and Chinese characters in the same
column of a table? If yes, then how?Yes, it's possible, but with the information you have given, it's difficult
to give exact advice.

First of all, which character set do you use for Chinese? Unicode? Big-5?
If you use Unicode, you should use ntext, if you use Big-5 or any other
non-Unicode character set, you should use text.

Next question is find out where things go wrong. Do something like:

SELECT substring(col, 1, 20), convert(binary(20), substring(col, 1, 20))

If there are question marks in the selected substring which should have
been Chinese characters, what do you see in their place in the binary
string? If you see 3F, the Chinese characters have been stored as ?, and
there is a problem on input. If you see the codes for the Chinese
characters, it's a display problem.

If it is an input problem, it would help to know who the characters enters
the database.

Disclaimer: I have no experience of working with Chinese on my own.

--
Erland Sommarskog, SQL Server MVP, esq...@xxxxxxxxxxxxx

Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

.

Relevant Pages

  • Re: Brian Kernighan, maybe Im not worthy, maybe Im scum
    ... but being a Chinaman his address is now in the Chinese characters. ... Foo Ying is also semiracist since it is an old-fashioned mis-spelling ...
    (comp.programming)
  • Re: .NET 2.0 - Sending Emails - Subject and Attachment Name Encoding Issues
    ... Chinese characters then the issue occurs. ... When the email is sent to a Microsoft Exchange Server email address ...
    (microsoft.public.dotnet.framework)
  • Re: Error 52: Bad File Name (Chinese characters)
    ... I think I'm going to need to load a library of chinese characters so my ... VBA can't read the spurious characters. ... And I guess that's the overall problem: VBA reads the characters as "?". ... Open FileName For Binary Access Read As f ...
    (microsoft.public.access.modulesdaovba)
  • Chinese Character Stroke Order Animator
    ... Yes, Chinese characters are difficult. ... That's exactly why "Chinese Character Stroke Order Animator" can help ... Multi-language interface including English, Simplified Chinese, ...
    (soc.culture.china)
  • Re: Stored proc with version number ?
    ... in addition to letter characters from other languages. ... Certain symbols at the beginning of an identifier have special meaning ... in SQL Server. ... I choose> the existing stored proc uspTableSave and right click Properties. ...
    (microsoft.public.sqlserver.programming)