Can I change the language settings after installation?

Hi All,

I have sql server 2005 dveloper edition installed on my XP pro. Both are English editions. I used the default language settings to install sql server 2005. The XP Pro has asian-language support installed and supports Chinese input.

I have tables with columns in nvarchar. But I can not input Chinese into the columns directly in the management studio or using sql statement.

How could I change the language so the Chinese chracaters being accepted?

Thanks a lot!

Gavin

You can change the collation sequence at the database, table, and column level. If you didn't specify any options, then the database will be created with your default collation sequence from the instance. If you change the collation sequence on the database or table to one compatible by the Chinese character set you are using, then you can input that data. You are going to need to drop and recreate the table since switching the collation sequence on the database doesn't automatically do so on the table.|||

Thanks Michael.

I remembered that it's not easy to do this in the previous versions (maybe I'm wrong?). So I think it is the same for 2005. When I was checking properties of the database, I noticed collation could be changed. I tried and it worked for me. I did not check the table and column level but I believe your are right. I may try them later.

Gavin