SQL Server's cultural sensitivities

by Michael S. Kaplan, published on 2005/11/29 09:31 -05:00, original URI: http://blogs.msdn.com/b/michkap/archive/2005/11/29/497852.aspx


Souri asked me:

Michael,

Does SQLServer 2005 support culture aware Sorting?

Thanks,
Souri

Hi Souri!

Not only does SQL Server 2005 do this, but SQL Server 2000 does as well; even SQL Server 7.0 supports a limited version of it.

But the word 'culture' in your question does seem to imply a connection to the .NET Framework, and just in case the question being asked of me was in reference to whether SQL Server 2005 supports the same collations as the .NET Framework, you will want to take a look at posts of mine like String.Compare is for sissies (not for people who want SQLCLR consistency) and Real developers use CompareInfo's Compare (Part 1) to see some of the things you need to do to make SQL Server and the CLR more compatible....

Note that these techniques will get you close but will not give you perfectly consistent results -- there is no way to make the match 100%.

 

This post brought to you by "Ǿ" (U+01fe, a.k.a. LATIN CAPITAL LETTER O WITH STROKE AND ACUTE)


no comments

Please consider a donation to keep this archive running, maintained and free of advertising.
Donate €20 or more to receive an offline copy of the whole archive including all images.

go to newer or older post, or back to index or month or day