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 |
|
Shamee_1321
Starting Member
15 Posts |
 Posted - 2008-02-15 : 06:33:03
|
| How can I change the collation of a db from Latin1_General_CI_AS to SQL_Latin1_General_CP1_CI_AS???? Is this possibleI am trying to map tables from 2 db... I am having error becoz of the collation.. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-02-15 : 06:36:32
|
Try this:Alter Database Db-name Collate SQL_Latin1_General_CP1_CI_ASGO But note that changing collation will have effect only on new tables created in the database, existing tables will continue to have same collation as earlier.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
Shamee_1321
Starting Member
15 Posts |
Posted - 2008-02-15 : 07:10:07
|
| No, this does not work... I have read a bit on collation.. It is said that when a db collation is altered.. the old tables in the db have the same collation as before. it is only for new table created that the new collation will be set |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-02-15 : 07:13:37
|
Great that you and Harsh said exact same thing.What is it you want Shamme_1321? You want to alter all collations on all existing tables and existing columns as well?See http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|
|
Collation issue