Case-sensitive queries in SQL Server, oracle, and Mysql Databases

By default, SQL Server queries are case-insensitive. That is, whereaABC is the same as wherea 'abc '.

By default, SQL Server queries are case insensitive. That is, where a = 'abc' is the same as where a = 'abc '.

However, we can determine whether the case is case sensitive by using the method.

Method 1:

Alter table tb (specify a column in a TABLE)
Alter column colname nvarchar (100) COLLATE Chinese_PRC_CI_AS -- case insensitive

Alter table tb (specify a column in a TABLE)
Alter column colname nvarchar (100) COLLATE Chinese_PRC_CS_AS -- case sensitive

Alter database COLLATE Chinese_PRC_CS_AS (specify the entire database)

Method 2:

Select * from servers where convert (varbinary, name) = convert (varbinary, n'rockey ')

ORACLE

The query in Oracle10g is case-sensitive by default (use SQL statements to query the current oracle version: select * from v $ version)

You can also set case insensitive here. The steps are as follows:

Alter session set NLS_COMP = ANSI; alter session set NLS_SORT = binary_ci;

:

The above is the content about case-sensitive queries in SQL Server, oracle, and Mysql databases. For more information, see PHP Chinese website (www.php1.cn )!