使用存储过程从sqlserver检索阿拉伯值,不给出任何值 [英] Retriving Arabic Value from sqlserver using stored procedure not giving any values
问题描述
Hai,
i am trying to get the Arabic matched values from the DataBase using stored procedure in sqlserver 2008..
But it didn't returns the matched values.. why..
My Table Design is like
CREATE TABLE #test1
(
col1 nVARCHAR(100) ,
col2 nVARCHAR(100) ,
col3 NVARCHAR(100)
)
INSERT INTO #test1 VALUES(N'لا أتكلم العربية',N'لا أتكلم العربية',N'لا أتكلم العربية')
INSERT INTO #test1 VALUES( ' fdfdf', 'dfdfdf', '45dfdf')
SELECT * FROM #test1
它很好地显示了结果,如下所示...
it showing the result like below well...
col1 col2 col3
لا أتكلم العربية لا أتكلم العربية لا أتكلم العربية
fdfdf dfdfdf 45dfdf
给定的查询给出确切的结果,而我正在搜索阿拉伯语单词..
The given query giving the exact results while i am searching for the Arabic words..
declare @ColVal nvarchar(100)
set @ColVal= N'لا أتكلم العربية'
print @ColVal
select * from #test1 where col2 like @ColVal
但是,当我尝试使用存储过程检索相同的数据时,即使它们存在于表中,它也不会再显示匹配记录.
我的存储过程是
But when i trying to retrieve the same data using the Stored Procedure it doesn''t showing the Matched records any more even they exist in table..
My stored Procedure is
create proc Sp_TestArabic1 (@colValue nvarchar(100))
as
declare @ColVal nvarchar(100)
begin
set @ColVal= 'N'+@colValue
print @ColVal
select * from #test1 where col2 like @ColVal
end
exec Sp_TestArabic1 'لا أتكلم العربية'
没有给出任何结果,我尝试调试存储的过程,所有列都很好地传递了值,但是它没有返回正确的结果..
请提供根据条件搜索阿拉伯语单词的准确解决方案...
谢谢..
Doesn''t give any results , I tried with debugging the Stored porcedure, all the columns passes the values well but it doesn''t returns the Correct results..
please provide exact solution to search the Arabic words based on the Condition...
Thank you..
推荐答案
从C#代码执行过程时,您需要传递带有"N"前缀的参数. 像这样
exec Sp_TestArabic1 N''لاأتكلمالعربية''
确保参数值应使用阿拉伯语,而不是N''???????
While executing the procedure from C# code, you need to pass parameter with ''N'' prefix.
like this
exec Sp_TestArabic1 N''لا أتكلم العربية''
Make sure the parameter value should be in arabic, not N''????''
这篇关于使用存储过程从sqlserver检索阿拉伯值,不给出任何值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!