How can I change the collation name of a specific database?
How can I change the collation name of a specific database?
Software/Hardware used:
Software/Hardware used:
ASKED:
May 28, 2008 5:14 AM
UPDATED:
May 28, 2008 12:49 PM
Answer Wiki:
The collation of a user database can be changed via the ALTER DATABASE command.
<pre>alter database MyDatabase
collate Latin1_General_BIN</pre>
You can see the list of available collations <a href="http://msdn.microsoft.com/en-us/library/ms180175.aspx">here</a> or by running the following SQL Command.
<pre>select *
from sys.fn_helpcollations()</pre>
To see all answers submitted to the Answer Wiki: View Answer History.
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.