例如,下一个查询确定AdventureWorks数据库默认的数据库排序规则(第一个参数是数据库名,第二个是要查看的Collation选 项): 1. SELECT DATABASEPROPERTYEX ( 'DataBaseName' , 'Collation' ) 1. 这个查询返回下面数据库的排序规则信息(在本例中它和SQL Server实例默认的一样,除非去显式修改它): 1. SQL_Latin1_...
If this option isn't selected, the collation is case-insensitive. That is, SQL Server considers the uppercase and lowercase versions of letters to be identical for sorting purposes. You can explicitly select case insensitivity by specifying _CI. Accent-sensitive (_AS) Distinguishes b...
SQL collation 31 diction.437 Dictionary order, case-sensitive SQL_Latin1_General_Cp437_CS_AS_KI_WI 32 nocase.437 Dictionary order, case-insensitive SQL_Latin1_General_Cp437_CI_AS_KI_WI 33 nocasepr.437 Dictionary order, case-insensitive, uppercase preference SQL_Latin1_General_Pref_Cp437_...
If this option isn't selected, the collation is case-insensitive. That is, SQL Server considers the uppercase and lowercase versions of letters to be identical for sorting purposes. You can explicitly select case insensitivity by specifying _CI. Accent-sensitive (_AS) Distinguishes between ...
For example, two tables with names different only in case may be created in a database with case-sensitive collation, but may not be created in a database with case-insensitive collation. For more information, see Database Identifiers.
Use the collation that is identified by Setup, and then choose the desired binary, case, or other option. When SQL Server Setup detects that the computer is running the U.S. English system locale, Setup automatically selects the Dictionary order, case-insensitive, for use with 1252 character...
CaseSensitivityCIspecifies case-insensitive,CSspecifies case-sensitive. AccentSensitivityAIspecifies accent-insensitive,ASspecifies accent-sensitive. BINSpecifies the binary sort order to be used. Remarks To list the SQL Server collations supported by your server, execute the following query. ...
CaseSensitivity CIspecifies case-insensitive,CSspecifies case-sensitive. AccentSensitivity AIspecifies accent-insensitive,ASspecifies accent-sensitive. BIN Specifies the binary sort order to be used. Remarks The following table lists the SQL Server collation names. ...
The CASE expressions in the following queries have a No-collation label; therefore, they cannot appear in the select list or be operated on by collation-sensitive operators. However, the expressions can be operated on by collation-insensitive operators.SQL Copy ...
To have SQL Server recognize trailing white spaces in passwords stored in the database, modify the Authenticate User query in the ODBC Query Scheme object using the Administrative UI. To have SQL Server compare strings without padding or trimming, incorporate the LIKE predicate instead of the=opera...