27,579
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM fn_helpcollations()
WHERE name LIKE 'Chinese[_]PRC%'
--假如数据库默认排序规则是COLLATE Chinese_PRC_CI_AS
SELECT
UCS_2 = CAST(N'中文' AS binary(4)),
CP936 = CAST( '中文' AS binary(4))
GO
SELECT
UCS_2 = CAST(0x2D4E8765 AS nchar(2)),
CP936 = CAST(0xD6D0CEC4 AS char(4))
GO
select convert(varchar(10),0xA7DAAC4FA448)
/*
§Ú¬O¤H
*/
select convert(varchar(10),0xA7DAAC4FA448)
/*
我是人
*/