Post reply

Collation problem

  • December 20, 2002 at 6:30 am

    #58658

    Hi,

    I made database on Sql Server 2000 with SQL_Latin1_General_CP1_CI_AS collation.How can I change collation to Slovenian_CI_AS. In fact, I only need to change collation on a few columns so I tried to change collation on them but it didn't work.

    Thanks,

    Jelena

  • December 20, 2002 at 11:24 am

    #444936

    u can run the alter table alter column to change the collation.

    alter table tablename alter column [test] [char] (22) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL

    But you have to make sure that no indexes or contrains existin on those columns.If they exist then drop tham and recreate them.

  • January 8, 2003 at 9:21 am

    #445856

    Thanks,but I still can't see letters è and æ, instead I always see c.

    Jelena

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply