question

Manikreddy avatar image
Manikreddy asked

can we change collation of the DB after it has filled with some data?

Can we change collation of the db after it has filled with some data..?
collation
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
Shawn_Melton avatar image
Shawn_Melton answered
Yes you can. There are some things to check prior to doing it. This link has the information: [ALTER DATABASE (Transact-SQL)][1] See the section "Changing the Database Collation" [1]: http://msdn.microsoft.com/en-us/library/ms174269.aspx
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image
Kev Riley answered
You can change the collation of a database at any time, but only new objects will have the new collation. To change existing objects you would need to script out each column of each object that has the collation (i.e. character fields) for example: ALTER TABLE MyTable ALTER COLUMN MyCol VARCHAR(10) COLLATE NewCollation [MSDN link][1] [1]: http://msdn.microsoft.com/en-us/library/ms190920.aspx
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.