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 |
|
alperozgur
Starting Member
16 Posts |
 Posted - 2004-12-08 : 04:52:37
|
| Hi;The collation of sql server is Turkish_ci_as. I want to change one of the databases collation from Turkish to Latin.Is there anyone knows how to do it? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-12-08 : 05:08:03
|
alter database DbName Collate CollationNameYouNeedGo with the flow & have fun! Else fight the flow  |
 |
|
|
Amethystium
Aged Yak Warrior
701 Posts |
Posted - 2004-12-08 : 05:55:36
|
quote:
Originally posted by alperozgur
Hi;The collation of sql server is Turkish_ci_as. I want to change one of the databases collation from Turkish to Latin.Is there anyone knows how to do it?
Do as Spirit suggested but remember that altering the collation will not have any effect on objects created prior the change. Only new objects will use the new collation so if you're after changing the collation of all objects in a database then it's a little bit more tricky.------------->>> BREAKING NEWS!!! <<<------------- Saddam Hussien has weapons of mass destrcution |
|
|
|
|
|
|
CHANGING COLLATION