Shulou(Shulou.com)05/31 Report--

This article introduces you to mssql case-sensitive, the content is very detailed, interested friends can refer to, hope to be helpful to you.

1.Mutual-case-sensitive

Select * from a where axioms AbCdE' collate Chinese_PRC_CS_AI-- is case sensitive

Select * from a where axioms abCdE' collate Chinese_PRC_CI_AI-- is not case sensitive

two。 If you want all storage tables on the server to be case-sensitive, you need to set the server's collation when you install the server

Or run

Alter database testgrass collate Chinese_PRC_CS_AI

3. If you change the default collation of the entire server, rebuild the master library with Rebuildm.exe

SQL Server\ 80\ Tools\ Binn\ rebuildm.exe

4. Or diagrams.

1. First open the oblog_user table of the oblog database, right-click, and select the design table

two。 Find the username field

3. Then find the following collation

4. Select case sensitivity in the pop-up dialog box

Reference:

We often come across statements like this when we are in create table, such as:

Password nvarchar (10) collate chinese_prc_ci_as null

So what exactly does it mean? Take a look at this:

First, collate is a clause that can be applied to a database or column definition to define a collation, or to a string expression to apply a collation projection. The syntax is:

Collate collation_name

Collation_name:: = {windows_collation_name} | {sql_collation_name}

The parameter collate_name is the name of the collation applied to an expression, column definition, or database definition. Collation_name can be just a specified Windows_collation_name or SQL_collation_name.

Windows_collation_name is the collation name of the Windows collation. See Windows collation name.

SQL_collation_name is the collation name of the SQL collation. See SQL collation name.

Here is a brief introduction to the collation:

What is a collation? MS describes it this way: "in Microsoft SQL Server 2000, the physical storage of strings is controlled by collations that specify the bit pattern that represents each character and the rules used to store and compare characters."

Execute the following statement within the query analyzer to get all the collations supported by SQL SERVER.

Select * from:: fn_helpcollations ()

The collation name consists of two parts, and the first half refers to the character set supported by this collation. Such as:

Chinese_PRC_CS_AI_WS

The first half: refers to the UNICODE character set, and Chinese_PRC_ refers to the sorting rules for mainland simplified characters UNICODE.

The second half of the collation is the suffix meaning:

_ BIN binary sort

Whether CI (CS) is case-sensitive, CI is not case-sensitive, CS is case-sensitive

Whether _ AI (AS) distinguishes stress, AI does not distinguish, AS distinguishes

Whether _ KI (KS) distinguishes katakana types, KI does not distinguish, KS distinguishes

Whether _ WI (WS) distinguishes width WI does not distinguish, WS distinguishes

Case sensitive: select this option if you want the comparison to treat uppercase and lowercase letters as unequal.

Distinguish stress: select this option if you want the comparison to treat accented and unstressed letters as unequal. If you select this option, the comparison also treats letters with different stresses as unequal.

Distinguish katakana: select this option if you want the comparison to treat katakana and katakana Japanese syllables as unequal.

Distinguish width: select this option if you want the comparison to treat half-width and full-width characters as unequal.

So much for case sensitivity in mssql. I hope the above content can be helpful to you and learn more. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.