i am passing where clause to store procedure execution. and searching Urdu language word
execute SPSearching @Mode ='Searching', @WhereClause= 'Hadith_Urdu Like N''%عبد%'''
but it doesnt provide me result whilc the serached word is present in database specified column
while my sp is
USE [SSDB2]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SPSearching]
@Mode varchar(50),
@WhereClause varchar(Max) = null
AS
if @Mode= 'ColumnNames'
BEGIN
SELECT column_name FROM information_schema.columns WHERE table_name = 'Hadiths_old'
END
if @Mode= 'Searching'
BEGIN
declare @SQL VARCHAR(MAX)
SET @SQL='Select [Hadith_Text]
,[Hadith_Urdu]
,[Hadith_English]
,[Chapter_English_Name]
,[Chapter_Urdu_Name]
,[Baab_English_Name]
,[Baab_Urdu_Name]
,[Baab_Id]
,[Hadith_Book_Number]
From Hadiths_old
Where '
IF @WhereClause<>''
SET @SQL=@SQL+' '+ @WhereClause + ' order by ID'
EXEC(@SQL)
END
if i try to search english word then it is searching very fine.
execute SPSearching @Mode ='Searching', @WhereClause= 'Hadith_English Like N''%allah%'''
but i dont know it not working with unicode i have prefixed my searched word with N but not working