Problem with 'case sensitive' after changing collation

( ) writes:
> the collation of my database was: "Latin1_General_CI_AI".
>
> I changed it for "Chinese_PRC_90_BIN" because I want to store chinese
> and english stuff.
>
> I used this SQL command:
>
>=======================
> USE myDataBase
>
> alter database myDataBase collate Chinese_PRC_90_BIN
>=======================
>
> Now I have many errors when I browse my web application because the
> database is now case-sensitive.
>
> How to disable "case-sensitive" and keep my new collation ?
>
> Server: Windows Server 2003
> BD: Sql Server 2005 Express Edition

The obvious choice seems to be:

ALTER DATABASE myDataBase COLLATE Chinese_PRC_90_CI_AI

A few comments:

As long as you use Unicode, you can store Chinese text with
Latin1_General_CI_AI as well, but obviously the Chinese data may not
be sorted correctly. If you store Chinese text in varchar columns,
you must use a Chinese collation.

Beware that changing the collation, only updates the system table.
If you have existing tables, you need to change the collation of
their character columns separately, one at a time.


--
Erland Sommarskog, SQL Server MVP, esquel DeleteThis @sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
 >> Stay informed about: Problem with 'case sensitive' after changing collation