How to retrieve data from SQL Server stored procedure by using hindi parameter

Question

How to retrieve data from a SQL Server stored procedure by using hindi parameter?

I have tried like this:

declare @A nvarchar (max), @b nvarchar(max), @c nvarchar(max)
set @b = N'नईम '
print @b

But used @b as a parameter then it will work :

declare @A nvarchar (max),@b nvarchar(max),@c nvarchar(max)
 set @b = 'नईम '
 print @b

then no results found

Pass hindi parameter like in sp :

[Up_searchbyperameter] 35,62,0,'नाम'

kindly give me any solution

In stored procedure, there is one parameter @datavalue which contain Hindi word, but by using stored procedure, I am unable to retrieve hindi data

Please help...

Try `EXEC [Up_searchbyperameter] 35,62,0,N'नाम' ` - note the `N` before the parameter input value. — gotqn, Apr 17 '15 at 13:32
possible duplicate of [What is the meaning of the prefix N in T-SQL statements?](http://stackoverflow.com/questions/10025032/what-is-the-meaning-of-the-prefix-n-in-t-sql-statements) — Tanner, Apr 17 '15 at 13:36
as per my requirement i have to pass only Hindi data and by using store procedure i want to retrieve this data from table this data already exist in table cant use N before the parameter — Nayeem Mansoori, Apr 17 '15 at 13:39
to use hindi character literals you must use N'...', otherwise it won't be a unicode string. — 1010, Apr 17 '15 at 14:02

Bacon Bits · Answer 1 · 2015-04-17T15:51:20.423

2

I'm not sure I understand exactly, but it looks like one of the problems is that you're using varchar literals when you need to use nvarchar literals.

You can see the problem if you run this:

SELECT 'नाम' "A",
    N'नाम' "B",
    cast('नाम' as nvarchar(10)) "C"

You should get these results:

A   B   C
--- --- ---
??? नाम ???

See how column A and C are unknown characters? That's because they were entered as varchar literals and not nvarchar literals. Hindi characters aren't valid in varchar fields, so they get converted to question marks.

So, if I understand what you're asking, I think you need to use:

declare @A nvarchar (max), @b nvarchar(max), @c nvarchar(max)
set @b = N'नईम'
exec [Up_searchbyperameter] 35,62,0,@b

edited Apr 17 '15 at 15:51

answered Apr 17 '15 at 13:49

Bacon Bits

30,782
5
59
66

[Up_searchbyperameter] 35,62,0,'नाम' i m pass likes this – Nayeem Mansoori Apr 17 '15 at 13:50
@NayeemMansoori Are you saying that running `exec [Up_searchbyperameter] 35,62,0,'नाम'` works, or that that's what you're trying and it does not work? – Bacon Bits Apr 17 '15 at 13:55
1

@NayeemMansoori Is the fourth parameter of `[Up_searchbyperameter]` defined in the stored procedure definition as a varchar or an nvarchar? It needs to be an nvarchar there, too, or you won't be able to use Hindi characters in the parameter. – Bacon Bits Apr 17 '15 at 14:00

How to retrieve data from SQL Server stored procedure by using hindi parameter

1 Answers1