如何设置数据库默认编码? [英] How do I set database default Encoding?
本文介绍了如何设置数据库默认编码?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何设置本地文件SQL-Server数据库的默认编码?
谢谢。
EDIT:已移除UTF-8
解决方案
更改以下新数据库的默认值:
alter database model collate SQL_Latin1_General_CP1_CI_AS
pre>
更改现有数据库的排序规则:
alter数据库YourDbName整理SQL_Latin1_General_CP1_CI_AS
可用的归类列表由系统函数返回:
select * from fn_helpcollations()
How do I set the the default encoding of my local file SQL-Server database?
Thanks.
EDIT: Removed the UTF-8
解决方案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()
这篇关于如何设置数据库默认编码?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文