ahmed sa

ahmed sa

  • NA
  • 289
  • 125k

Arabic langauge not display when i make search by arabic lan

Sep 6 2014 1:40 AM

Hi guys

I have database hr has table Employee this table  has field EmployeeName

EmployeeName  nvarchar(50)

when i write in query analyzer :

select ^ from Employee where EmployeeName='????'

not give me any result

but when i write

select * from Employee where EmployeeName=N'????'

it give me result

meaning it support arabic

but i have stored procedure not accept arabic and i dont know how to handel it to accept search by EmployeeName

CREATE Procedure sp_EmployeeSelect
@EmployeeName      nvarchar(50)  
AS  
Declare @SQLQuery as nvarchar(2000)
SET @SQLQuery ='SELECT * from Employee Where (1=1)'  
If @EmployeeName  <>''
Set @SQLQuery = @SQLQuery + ' AND (EmployeeName  LIKE ''%'+@EmployeeName +'%'') '
Exec (@SQLQuery)

what is the proplem in this stored procedure and how to solve it

please help me


Answers (1)