Collation and SQL

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Paul White » Collation and SQL_VARIANT

42 posts, Page 5 of 5

«««1 2 3 4 5

Collation and SQL_VARIANT

Rate Topic

Display Mode

Topic Options

Author

Message

jswong05

Posted Tuesday, November 15, 2011 9:43 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, March 18, 2013 7:54 AM
Points: 27, Visits: 421

To me the answer should not depend on data type.

C - case
I - Insensitive
A - Accent
S - Sesitive

b and B cannot be Accent differentiated
b and B cannot be Case differentiated

Jason
http://dbace.us
Tongue

Post #1206112

Paul White

Posted Tuesday, November 15, 2011 10:27 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 7:53 AM
Points: 10,990, Visits: 10,577

jswong05 (11/15/2011)

To me the answer should not depend on data type.

C - case
I - Insensitive
A - Accent
S - Sesitive

b and B cannot be Accent differentiated
b and B cannot be Case differentiated

The point is the values in the column have different collations, and SQL Server cannot directly compare strings from different collations. For SQL_VARIANT data containing strings to compare equal, the collation must be the same first.

Not sure what you mean by 'b' AND 'B' cannot be 'case differentiated' - they have different casing!

Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi

Post #1206174

« Prev Topic | Next Topic »

42 posts, Page 5 of 5

«««1 2 3 4 5

Permissions