请问sql server的默认字符集在什么地方设置

[tracyywb]

请问，SQL SERVER的默认字符集在什么地方设置。

[点点星灯]

sp_helpsort
显示 Microsoft® SQL Server™ 排序次序和字符集。

语法
sp_helpsort

返回代码值
0（成功）或 1（失败）

结果集
返回服务器默认排序规则

权限
执行权限默认授予 public 角色。

示例
下面的示例显示了服务器默认排序次序的名称、字符集以及一个包含其主要排序值的表。

sp_helpsort
go

下面是结果集。

Server default collation
------------------------
Latin1-General, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 51 on Code Page 1252 for non-Unicode Data.

[suntt]

使用下面这个查询所有的字符集
SELECT *
FROM ::fn_helpcollations()

单独要看数据库的字符集情况
可用:
sp_helpdb
也可以用
select DATABASEPROPERTYEX( 'dbname','Collation')

[qingsongy]

it is set during installation. The default character set is control by the server's collation name.

For example, collation sql_latin1_general_cp1_ci_as use 1252 latin character set.
collation chinese_prc_ci_as use chinese character set.

There is no easy way to change default character, except that you can re-install the SQL Server or use a program rebuildm to rebuild master database.

Note: you may not need to change server's character set since each database have there own character set. during creating database, you can choose a collation you want, then it should work fine.

[marco08]

楼上的强