|
Home > Archive > MS SQL Server > December 2005 > SQL2000 Chinese Character problem
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL2000 Chinese Character problem
|
|
| Jason Huang 2005-12-28, 3:23 am |
| 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
| |
| James Ma 2005-12-28, 1:23 pm |
| 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
>
>
>
| |
| Jason Huang 2005-12-28, 8:23 pm |
| Thanks James, this works!
"James Ma" <JamesMa@discussions.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D:524DD
4A7-5E9C-4CA4-84F9- 4000680D6D0F@microso
ft.com...[color=darkred]
>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:
>
|
|
|
|
|