varbinary转出中文编码的问题+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

[brucely]

A的GB编码是0x41
unicode是0x0041
我用select convert(varchar(800),0x41)可以显示A
用select convert(varchar(800),0x0041)看不到结果
用select convert(nvarchar(800),0x0041)结果是一个乱码

汉字“你好”的GB编码是0xC4E3BAC3
unicode是0x4F60597D
用select convert(varchar(800),0xC4E3BAC3)显示你好
用select convert(varchar(800),0x4F60597D)
select convert(nvarchar(800),0x4F60597D)

请问用什么方法unicode的才能看到这个字符值内容

[brucely]

自己up，mark！

[知识青年]

A 的 unicode是 0x4100吧 DECLARE @a NVARCHAR(10)='A' SELECT CAST(@a AS VARBINARY(100)) --0x4100 SELECT CAST(0x4100 AS VARCHAR(10)) SELECT CAST(0x4100 AS NVARCHAR(10)) SET @a='你好^_^' SELECT CAST(@a AS VARBINARY(100)) SELECT CAST(0x604F7D595E005F005E00 AS VARCHAR(10)) SELECT CAST(0x604F7D595E005F005E00 AS NVARCHAR(10))