April 28, 2010 at 6:08 am
Hi all,
I just changed the collation of a database from default SQL_Latin1_General_CP1_CI_AS to Latin1_General_CI_AS. But originally some columns in the database explicitly had Latin1_General_Bin collation. Currently the database default collation is Latin1_General_Bin, none of the columns have explicit collation. Do we need to specify the collation explicitly? Also wondering if Latin1_General_Bin and Latin1_General_CI_AS are the same, or am I looking for trouble?
Thank you
April 28, 2010 at 3:39 pm
Boy....good luck. I recently had an issue with collate in Crystal Reports and SQL 2000 and it wasn't pretty. Try these urls:
http://www.sqlservercentral.com/Forums/Topic909786-146-1.aspx
http://msdn.microsoft.com/en-us/library/ms143515(v=SQL.90).aspx
http://msdn.microsoft.com/en-us/library/ms144260.aspx
...to get some basic information. I "think" there is some SQL code that you can use to finish up the collation change. Once you change the db, you have to change ALL table columns to the 'new' collation setting as well. My problem was SQL 2005 at the default Latin1_General_CP1_CI_AS with the database being Latin1_General_CP1253_CS_AS....and later I discovered that the DBA/programmer had hard coded the _CP1253 collation into 5 stored procs when building #temp tables......talk about a nightmare. Nothing would run against the db ( of course the DBA is no longer with us...) after an upgrade to VM. Great fun. If you can't find the SQL, please advise. JNelson
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply