April 22, 2008 at 11:04 am
Hi all,
I am researching on how I can change the default collation for the existing columns to Latin1_General_BIN, both in sql 2000 and 2005 databases. I came across few methods to do it but no success so far. I think the alter database set collation command will set the database default but wont help for the existing columns. And I tried to detach database,
change the collation in the script are reattach the database ,but getting constraint errors..
Any suggestions will be appreciated. THanks much.
April 22, 2008 at 11:10 am
You have to change collation on database AND on existing columns.
So alter database and set of alter table alter column statements is the way to go.
Regards,
Piotr
...and your only reply is slàinte mhath
April 22, 2008 at 11:17 am
Yes, I am aware that it is an option to change using alter column statement, but even then there will be constraints dependency on them, so I am unable to just change the collation. Also, there are like 150 tables I'll have to change the column collation for. I was wondering if there is a easy/better way to do this, I am not aware of.
Thank you.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply