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: 2 days ago @ 10:00 AM
Points: 8,551, Visits: 9,043
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 @ 2:59 AM
Points: 568, Visits: 69,689
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 @ 7:44 PM
Points: 21,209, Visits: 14,899
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 @ 7:05 PM
Points: 5,566, Visits: 24,734
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 @ 2:53 PM
Points: 3,786, Visits: 1,084
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
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: Tuesday, July 22, 2014 1:19 AM
Points: 1,282, Visits: 1,114
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: Sunday, July 20, 2014 11:20 PM
Points: 13,252, Visits: 10,133
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: Yesterday @ 1:50 PM
Points: 5,974, Visits: 12,877
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