How do you change the default encoding on SQL server?

ziycon

I'm wondering how you change the default encoding on SQL server and also how do you change the encoding on existing tables in a SQL DB?

b0010100

Do you mean change the default collation for new databases? Change the collation of the model database:

Expand|Select|Wrap|Line Numbers

 
USE [master]

GO

ALTER DATABASE [model] COLLATE [SomeNewCollation]

GO

Change the Collation for a single database:

Expand|Select|Wrap|Line Numbers

 
USE [master]

GO

ALTER DATABASE [MyDB] COLLATE [MyNewCollation]

GO

re: How do you change the default encoding on SQL server?