September 21, 2011 at 5:33 am
Hello,
I hope someone can help, I am trying to install a collation of SQL_Latin1_General_CP1_CI_AS on my SQL 2005 R2 build. I understand that the OS regional settings have an influence on this an at setup I choose the SQL collations, but I cannot work out from the list which one I need to pick to get the collation I am after. I thought I had the right one at some point but ended up with SQL_Latin1_General_CP1_CI_AI so the AI and AS were different. I do not understand why M$ just doesnt list the damn collation names.
I have looked online and done the same as other that requir the same collation, but its just not turning out right. The last choice I made was SQL Collations and Dictionary Order, Case-Sensitive, Accent-Sensitive, for use with 1252 Character Set.
Could someone please tell me which one I need to choose to have a collation of SQL_Latin1_General_CP1_CI_AS, please? Thanks in advance.
D.
September 21, 2011 at 6:16 am
Run this (on another box, obviously):
select *
from fn_helpCollations()
where name = 'SQL_Latin1_General_CP1_CI_AS'
Turns out that the description is "Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode Data".
Hope this helps
Gianluca
-- Gianluca Sartori
September 21, 2011 at 8:45 am
Marvelous, thank you very much!
Regards,
D.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply