Posted by Erland Sommarskog on 09/26/23 11:47

Alexander Kuznetsov (AK_TIREDOFSPAM@hotmail.COM) writes:
>> Note that binary <> case-sensitive in SQL Server.
>
> yes, but you need < and > comparisons to navigate an index. I guess
> Finnish_Swedish_CS_AS collation is implemened as a function. As such,
> it probably works a little bit slower than raw bytes comparison,
> probably no big deal, just a little bit slower. Makes sence?

Exactly how Finnish_Swedish_CS_AS is implemented I don't know, but
I don't think the difference is smaller with regards to Finnish_Swedish_BIN
than to Finnish_Swedish_CI_AI.


--
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

• Next in forum: NovelSpace Media, LLC announces the launch of their new online bookstore and web portal devoted to developers and programmers.
• Prev in forum: Re: SQL2005 collation vs Oracle
• Thread view: Re: SQL2005 collation vs Oracle

[Reply to this message]