SQL Server 2000 supports case sensitivity

Because the local database is not set to partition size during installation, but the server is a partition, I re-wrote some code, in order not to let this happen, I decided to change the local database to support the size of the region.

 

The Code is as follows:

Alter database databasename
Collate chinese_taiwan_stroke_cs_as

CiCase Insensitive,CSSpecifies the case sensitivity.

If it is a simplified version, it should be chinese_prc_cs_as.

For detailed Encoding instructions, see

Http://msdn.microsoft.com/zh-cn/ms188046.aspx

You can directly use the rebuildm.exe tool.

In this case, the data created later will automatically support the large and small partition.

However, there will be no previous data records after use, but you need to append them once.

After attaching, the operation on these data rows will be supported.

At present, the younger brother has not found a way to complete the change.