公告
财富商城
积分规则
提问
发文
2019-04-10 01:38发布
Lonely孤独者°
How do I set the the default encoding of my local file SQL-Server database?
Thanks.
EDIT: Removed the UTF-8
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
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()
/*!40101 SET NAMES utf8 */
Something like that
最多设置5个标签!
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
Assuming by encoding you mean collation, you can change the default for new databases like:
The change the collation of an existing database:
The list of available collations is returned by a system function:
Something like that