April 15, 2007 at 9:58 pm
I have a problem with SQL 2005 Collations
The database have the correct collation, also de master database, but the tables, columns and fields have wrong database.
How can I fix the tables to the correct collation in few steps, instead of changing each column or field?
Regards
Mauricio Rodriguez
April 17, 2007 at 2:46 pm
If you post this in the SQL 2005 forum you may get better results.
So, your database is CollationA, but the columns Are CollationB ? How did the collation get wrong for the columns, if the database is correct ? Maybe it's intentional to be different ?
I took a quick look, and it seems that collation is set for a database, and columns, but not for the table as a whole.
April 17, 2007 at 3:13 pm
Yes Colation A is correcto for a DB, but columns are in collationB. I don't know how this occurs, but the application have bugs that occurs for the collations.
Yes, the database is correct, the column are correct and the tables are wrong.
I hope you can help me
Regards
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply