Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-08-02 : 10:49:03
|
| Ramesh Siva writes "I have two databases. First Database collation is Latin1_General_BINSecond Database collation SQL_Latin1_General_CP1_Cl_AS.I have used Alter Database command to change the second database collation to Latin1_General_BIN and then using sysobjects changed collation property for all fields in all tables where collation is not null.Then when i'm joining the two databases and try to retrieve some values, I'm facing invalid collation property error. But when i see the database properties, the collation has changed and also in tables it is database default. Can any one tell why my query didnt return any values eventhough both databases collation property is same now." |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-08-02 : 11:00:13
|
| The tables you had already created will not have changed collation because you changes the Database Collation. You will need to alter that on each column - which basically means creating a temporary table, copying all the data into the temporary table, and then dropping the old table and renaming the Temp to become the Original name.Kristen |
 |
|
|
|
|
|
Collation property in SQL Database.