是Unicode编码的意思,一般来说,英文字符是一个字节组成,但是国际上的字太多了,因此就用两个字节来表示字符,满足国际化的需要.
if your database's collation is english collation, such as sql_latin1_general_ci_as, and
if you want to input chinese characters into a nvarchar column, then you have to use
N'字符' to input chinese.
Note: '字符' is wrong character string for english collation, and can not be inserted into any varchar/nvarchar column
SQL语句里nchar类型的字段我不想加N,怎么办?
try:
更改排序规则。
alter database 数据库 collate 排序规格
使用如下命令,可以获得更多的规则:
SELECT *
FROM ::fn_helpcollations()
如:
简体
alter database 数据库 COLLATE Chinese_PRC_CI_AS
繁体
alter database 数据库 COLLATE Chinese_Taiwan_Bopomofo_CI_AS
if your database's collation is english collation, such as sql_latin1_general_ci_as, and
if you want to input chinese characters into a nvarchar column, then you have to use
N'字符' to input chinese.
Note: '字符' is wrong character string for english collation, and can not be inserted into any varchar/nvarchar column
SQL语句里nchar类型的字段我不想加N,怎么办?
try:
更改排序规则。
alter database 数据库 collate 排序规格
使用如下命令,可以获得更多的规则:
SELECT *
FROM ::fn_helpcollations()
如:
简体
alter database 数据库 COLLATE Chinese_PRC_CI_AS
繁体
alter database 数据库 COLLATE Chinese_Taiwan_Bopomofo_CI_AS