Use the following command to change the default character set:
1> sp_configure "default character set id", charset_ID 2> go
