sql server查询中文该怎么处理

Question

declare @name nchar(128)

set @name='123'

select stuffname from huqiangdataset.dbo.T_stainlesssteelstuff where stuffname=@name

当@name中含有中文时就查询不到结果，中文该怎么处理

Answer 1

CREATE TABLE [T1] ([NAME] NVARCHAR(255))
GO

INSERT INTO [T1] VALUES(N'中国')
GO
INSERT INTO [T1] VALUES(N'北京')
GO
INSERT INTO [T1] VALUES(N'上海')
GO

SELECT * FROM [T1]
GO

DECLARE @NAME NCHAR(128)
SET @NAME = N'中国'
SELECT * FROM [T1] WHERE [NAME]=@NAME
GO

DROP TABLE [T1]
GO