|
|
Posted by Erland Sommarskog on 10/02/64 11:47
Alexander Kuznetsov (AK_TIREDOFSPAM@hotmail.COM) writes:
> on one hand, I would concur: in most cases we need case insensitive
> data in the database. For instance, we in our shop uppercase all the
> data when we load it into Oracle. On the other hand, I think that case
> sensitive indexes may be implemented more efficiently than case
> insensitive ones, just because binary (case sensitive) comparisons are
> the fastest ones possible. However I am not sure what the performance
> gain might be...
Note that binary <> case-sensitive in SQL Server. That is, a binary
collation is case-sensitive, however the reverse does not apply. My
standard collation is Finnish_Swedish_CS_AS, and it's binary. It co-
sorts V and W, Y and Ü.and sorts ÅÄÖ in the right order.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|