使sql server数据区分大小写 [英] making sql server data case sensitive

问题描述

如何使sql server数据区分大小写..我正在使简单的登录页面..但是用户名在sql server中不区分大小写..它适用于查询e.g

how to make sql server data case sensitive.. i am making simple login page.. but username is not case sensitive in sql server.. it works on with both in query e.g

where username='DAVID' AND on where username='david'

我想使其区分大小写

i want to make it case sensitive

推荐答案

此查询的结果取决于您选择的排序规则的类型.
默认情况下，它不区分大小写(CI).
您可以在数据库级别或特定列上进行更改.
看看这些文章:
http://msdn.microsoft.com/en-us/library/ms184391.aspx [ ^ ]
http://msdn.microsoft.com/en-us/library/ms144260.aspx [ ^ ]

Result of this query depends on the type of collation you have chosen.
By default it''s case insensitive (CI).
You can change it on database level or on specific column.
Take a look at these articles:
http://msdn.microsoft.com/en-us/library/ms184391.aspx[^]
http://msdn.microsoft.com/en-us/library/ms144260.aspx[^]

where username=@username COLLATE SQL_Latin1_General_CP1_CS_AS

>

这将比较username列和传入的@username参数的情况.

This will compare the case of username column and the @username parameter being passed in.

这篇关于使sql server数据区分大小写的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！