Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

Object_Id 1 Expand / Collapse
Author
Message
Posted Thursday, February 23, 2012 8:16 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 2:18 PM
Points: 8,706, Visits: 9,253
Nice easy question, nice straightforward answer and explanation.

I guess that particular collation was chosen to demonstrate that not all T-SQL is case insensitive even when the collation is ..._CI_.. ?


Tom
Post #1256699
Posted Thursday, February 23, 2012 8:23 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:53 AM
Points: 1,176, Visits: 778
SQL Kiwi (2/23/2012)
And once again I fail as a T-SQL parser.


+1
Post #1256708
Posted Thursday, February 23, 2012 8:57 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 4:44 AM
Points: 568, Visits: 71,253
Needed a simple one today. Thanks for the question.
Post #1256736
Posted Thursday, February 23, 2012 9:09 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 1:55 PM
Points: 21,638, Visits: 15,305
EZ PZ lemon SQeZ



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1256749
Posted Thursday, February 23, 2012 9:14 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 4:44 PM
Points: 5,589, Visits: 24,962
L' Eomot Inversé (2/23/2012)
Nice easy question, nice straightforward answer and explanation.

I guess that particular collation was chosen to demonstrate that not all T-SQL is case insensitive even when the collation is ..._CI_.. ?


Your absolutely correct, and since QOD can be / or is a teaching tool for some I felt it was a little plus item to show


If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1256758
Posted Thursday, February 23, 2012 12:47 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 3:10 PM
Points: 3,796, Visits: 1,145
Thank you for the easy one.

As far as I know, collation is in part used for handling string literals, isn't it? It shouldn't affect syntax.

------------
A watt of Ottawa.
"El" Jerry.


"El" Jerry.

"A watt of Ottawa" - Gerardo Galvan

To better understand your help request, please follow these best practices.
Post #1256918
Posted Thursday, February 23, 2012 8:00 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, May 15, 2014 8:37 PM
Points: 589, Visits: 2,437
I finally understand why I see the N' in some queries and why I got "H e l l o " instead of "Hello" (with space between chars) when the application queried the "nvarchar" columns when I was creating the database. I swiched to varchar instead of taking the time to understand...

Thanks!

Is someone knows where to find the list of possible collation and if they are insensitive?
Post #1257054
Posted Thursday, February 23, 2012 8:35 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, August 11, 2014 10:25 PM
Points: 1,287, Visits: 1,116
I scored one today. Thanks for the easy question.
Post #1257069
Posted Friday, February 24, 2012 12:55 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 5:01 AM
Points: 13,605, Visits: 10,480
Thanks, nice question.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1257173
Posted Friday, February 24, 2012 6:43 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, August 21, 2014 3:52 PM
Points: 5,988, Visits: 12,923
BarbW (2/23/2012)
Good syntax question; not sure why collation info was included. Thanks!


I guess so we knew it was a case insensitive collation


---------------------------------------------------------------------

Post #1257376
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse