Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2002
    Posts
    4

    Unhappy Unanswered: 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,

  2. #2
    Join Date
    Nov 2002
    Posts
    24

    Post Unicode

    Your collation should be unicode with binary sort order. If it is not make it so..
    TECMAN

  3. #3
    Join Date
    Dec 2002
    Posts
    4

    Re: Unicode

    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?

  4. #4
    Join Date
    Nov 2002
    Posts
    24

    BOL

    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
    TECMAN

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •