CODEWITHSUNDEEP
sqlsql-server-2008collation
Kitamo
Kitamo

Reputation: 87

SQL Server collation: lowercase preference

I have SQL Server 2008 and was looking for collation with lowercase preference for case sensitive characters and wasn't able to find any!

http://msdn.microsoft.com/en-us/library/ms144250(v=sql.105).aspx

So, is there any CS collation with lowercase preference?

Upvotes: 1

Views: 1935

Answers (1)

Oded
Oded

Reputation: 499072

This is not possible.

Collations are either case sensitive (CS) or not (CI).

There is no upper/lower case collation.

I don't even understand what a case sensitive collation with preference for lower case even means, unless you are talking about sort order (lower case letters before upper case), but even so, this is not possible with the existing collations.

Upvotes: 4

Related Questions