存储过程中乱码问题

[验证码识别]

set @sql='select * from character as tab1 where ''' 	+ @realmkors +''' like   realmkor   '

print @realmkors
print @sql

输出
----------------------------------------
노르간논
select * from character as tab1 where '????' like realmkor
---------------------------------------

为什么 @realmkors 在@sql中是乱码

[叶子]

[Quote=引用 6 楼 yzm888 的回复:]

引用 5 楼 maco_wang 的回复:
SELECT的结果中出现"乱码"的解决方案

不管用
SQL code

set @realmkors = N'노르간논'
set @sql='select * from character as tab1 where ''' + @realmkors +''' like realmkor '

print @realmkor……
[/Quote]
看不到你变量的定义，你的是nvarchar类型的吗？

[叶子]

declare @realmkors nvarchar(100);set @realmkors = N'노르간논'
declare @sql nvarchar(1000)
set @sql=N'select * from character as tab1 where '''+@realmkors+''' like realmkor'

print @realmkors
print @sql
/*
노르간논
select * from character as tab1 where '노르간논' like realmkor
*/

[Zoezs]

set @sql='select * from character as tab1 where N'''     + @realmkors +''' like   realmkor   '

print @realmkors
print @sql

[快溜]

노르간논是韩文？。。。你传的是什么。。。

[验证码识别]

[Quote=引用 2 楼 ssp2009 的回复:]
노르간논是韩文？。。。你传的是什么。。。
[/Quote]
exec [InfoBase].pro_Seach N'노르간논' ...

这种， 一个存储过程里的参数

[叶子]

SELECT的结果中出现"乱码"的解决方案

[验证码识别]

[Quote=引用 1 楼 zoezs 的回复:]
SQL code


set @sql='select * from character as tab1 where N''' + @realmkors +''' like realmkor '

print @realmkors
print @sql
[/Quote]
输出
----------------
노르간논
select * from character as tab1 where N'????' like realmkor

[验证码识别]

[Quote=引用 5 楼 maco_wang 的回复:]
SELECT的结果中出现"乱码"的解决方案
[/Quote]
不管用

set @realmkors = N'노르간논'
set @sql='select * from character as tab1 where ''' 	+ @realmkors +''' like   realmkor   '

print @realmkors
print @sql

---------输出---------
노르간논
select * from character as tab1 where '????' like realmkor

[快溜]

--try
declare @realmkors nvarchar(100),@sql nvarchar(1000)
set @realmkors = N'노르간논'
set @sql=N'select * from character as tab1 where '''     + @realmkors +''' like   realmkor   '

print @realmkors
print @sql