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 - 2002-11-26 : 08:46:27
|
| Konrad writes "I have problem with database collation restored from sql server 7 on new sql2000. After restoring collation of database is Hungarian_BIN (because sql7 with code page 1250 and sql collation 80 was the same for all CE countries), but I need now Polish_BIN. I used Alter database <dbname> collate Polish_BIN, and it works.... but only for database collation... Now I need collate each table and each column.. I tried alter table but with error: [Microsoft][ODBC SQL Server Driver]Syntax error or access violation. So I tried to update table syscolumns in collationid column from 65549 to 65555 (Polish_BIN) but I know that interference in system tables is not recommended. I suppose that the same effect I will have when I use Enterprise manager and Design table option, but I am not sure if alter table do the same as I.Please if anybody knows nice solution for collation problems in existing databases let me know.RegardsKonrad" |
|
|
Konrad
Starting Member
2 Posts |
|
|
|
|
|
Collation on sql server 2000 
Tere is excellent way to evade the problem: