SQL2000 Chinese Character problem

Hi,

My SQL2000 is Traditional Chinese version.
In most cases, I can INSERT and SELECT correctly.
However, there some Chinese words I can INSERT without problem,
but the output of the SELECT will be "?", not the word I input to the
database.
Would anyone tell me the solution?
Thanks for help.


Jason

I assume you are working in the Query Analyzer. Notice following points:
1. The column must be nvarchar type
2. In the SQL, you must use N'...' on your chinese string
3. Save the script in UNICODE text file.
4. Configure the QA to use proper font to show chinese characters.

"Jason Huang" wrote:

> Hi,
>
> My SQL2000 is Traditional Chinese version.
> In most cases, I can INSERT and SELECT correctly.
> However, there some Chinese words I can INSERT without problem,
> but the output of the SELECT will be "?", not the word I input to the
> database.
> Would anyone tell me the solution?
> Thanks for help.
>
>
> Jason
>
>
>

Thanks James, this works!

"James Ma" <JamesMa@discussions.microsoft.com>  ¼¶¼g©ó¶l¥ó·s»D:524DD
4A7-5E9C-4CA4-84F9-40006
80D6D0F@microsoft.com...
>I assume you are working in the Query Analyzer. Notice following points:
> 1. The column must be nvarchar type
> 2. In the SQL, you must use N'...' on your chinese string
> 3. Save the script in UNICODE text file.
> 4. Configure the QA to use proper font to show chinese characters.
>
> "Jason Huang" wrote:
>