• 欢迎访问搞代码网站,推荐使用最新版火狐浏览器和Chrome浏览器访问本网站!
  • 如果您觉得本站非常有看点,那么赶紧使用Ctrl+D 收藏搞代码吧

SQL SERVER中文乱码解释~_sqlserver

sqlserver 搞代码 3年前 (2018-06-16) 122次浏览 已收录 0个评论

run sp_help “your table” to get the collation setting for the column.  In order to store chinese correctly, you should set the collation be:
    Chinese_PRC_CI_AS
 or Chinese_Stoke_CI_AS

char/varchar data type is ANSI char which must define a code page. If you set the collation be SQL_Latin1_General_CP_CI_AS, it can only store latin characters. In order to store chinese character in a char column, you have to set the collation be  Chinese_PRC_CI_AS  or Chinese_Stoke_CI_AS which has a chinese code page defined.

nchar/nvarchar collumn is different, you can store any Unicode character include enlish, chinese, japanese in one column.

In term of input chinese character, the character constant will use database’s collation. Thus, if the database’s collation is not chinese collation, there is no way to input chinese char/varchar data, such as 
‘中文’ will be treated as ‘??’.  But for nvarchar/ncar, you can input it
on any collation. such as  N’中文’ will be treated as two unicode chars

http://www.gaodaima.com/36081.htmlSQL SERVER中文乱码解释~_sqlserver

欢迎大家阅读《SQL SERVER中文乱码解释~_sqlserver,跪求各位点评,若觉得好的话请收藏本文,by 搞代码


喜欢 (0)
[搞代码]
分享 (0)
发表我的评论
取消评论

表情 贴图 加粗 删除线 居中 斜体 签到

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址