display japanese problem using sqlserver 2000

hi,

I have installed sqlserver 2000 under windows2000 on my PC. I found that the result set cannot display japanese correctly..it just show out '??'. I have already set the locale on my windows2000 to japanese, but it still doesn't work.. pls help...thx.

best regards,Your collation should be unicode with binary sort order. If it is not make it so..|||Originally posted by tecman
Your collation should be unicode with binary sort order. If it is not make it so..

thanks... but how can I do that?
besides, can I set the table to store multi-language columns which means some columns are in japanese, and some is other languages?|||You can change the collation of a column by using the ALTER TABLE statement:

CREATE TABLE MyTable
(PrimaryKey int PRIMARY KEY,
CharCol varchar(10) COLLATE French_CI_AS NOT NULL
)
GO
ALTER TABLE MyTable ALTER COLUMN CharCol
varchar(10)COLLATE Latin1_General_CI_AS NOT NULL
GO

You cannot alter the collation of a column that is currently referenced by:

A computed column.

An index.

Distribution statistics, either generated automatically or by the CREATE STATISTICS statement.

A CHECK constraint.

A FOREIGN KEY constraint.
You can also use the COLLATE clause on an ALTER DATABASE to change the default collation of the database:

ALTER DATABASE MyDatabase COLLATE French_CI_AS

Altering the default collation of a database does not change the collations of the columns in any existing user-defined tables. These can be changed with ALTER TABLE. The COLLATE CLAUSE on an ALTER DATABASE statement changes:

--BOL