Collation Latin1_General_CI_AS stands for?
-
Any idea what Latin1_General_CI_AS stands for? I mean what CI and AS stands for? I think the default collation is SQL_Latin1_General_CP1_CI_AS. Also what CP1 stands for?
Thanks
Regards - JL
-
CI - Case Insensistive
AS - Accent Sensitive
____________________________________________________
Deja View - The strange feeling that somewhere, sometime you've optimised this query before
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
-
CP1 = Code Page 1252, which is the set of characters supported.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
-
It is actually a combination of both what Mark and GSquared posted. It means that SQL Server is going to use the Code Page 1252 characters and searches are Case Insensitive and Accent sensitive.
Gary Johnson
Sr Database Engineer
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply