How do I set database default Encoding?

2019-04-10 01:38发布

How do I set the the default encoding of my local file SQL-Server database?

Thanks.

EDIT: Removed the UTF-8

3条回答
太酷不给撩
2楼-- · 2019-04-10 01:51

SQL Server does not support UTF-8.

Use nvarchar (UTF-16) if you don't mind using double space or varbinary if you don't need sort/indexing/comparison.

It may be supported in next release of SQL Server according to this post

查看更多
▲ chillily
3楼-- · 2019-04-10 01:54

Assuming by encoding you mean collation, you can change the default for new databases like:

alter database model collate SQL_Latin1_General_CP1_CI_AS

The change the collation of an existing database:

alter database YourDbName collate SQL_Latin1_General_CP1_CI_AS

The list of available collations is returned by a system function:

select * from fn_helpcollations()
查看更多
祖国的老花朵
4楼-- · 2019-04-10 01:55
/*!40101 SET NAMES utf8 */

Something like that

查看更多
登录 后发表回答