Collation Setting on New Server
Posted on 2010-11-15
I'm going to be moving the database on my existing SQL 2005 server, to a new server running the same version of SQL.
The old server was built before my time, and from what I'm reading, I need to match the collation settings on the new server to the old server for the databases to work properly after I move them over.
On the current server, if I do a properties on the server instance at the top of the management studio, and choose properties it says the collation settings are the following:
During the installation of the new server, I'm stuck on the collation settings part. By Default SQL collations is selected (the bottom radio button that refers to being compatible with earlier versions of SQL). I'm guessing that I need to change it to the top radio button (Collation designator and sort order) and choose Latin1_General, but at unsure of what sub-options to check:
Binary, Case - sensitive, Accent - sensitive, Binary - code point, Kana - sensitive, Width - sensitive
I'm sure that's what the CP1, CL, and AS represent, but I don't know what to pick. Thanks!
[EDIT] After reading a little more, it also appears that leaving the setting at the default (bottom radio button) also gives me Latin General, so I'm really not sure what was selected on the initial install of the original server.