Display Chinese Characters in SQL

-- TO REMOVE ALL UNWANTED TERMS FROM THE STRING AND DISPLAY CHINESE , RUSSIAN AND ENGLISH, DUTCH, GERMAN....  CHARACTERS

 

CREATE PROCEDURE  [dbo].[XXX]       

 @UserName nvarchar(32)       

AS       

BEGIN       

 -- SET NOCOUNT ON added to prevent extra result sets from       

 -- interfering with SELECT statements.       

 SET NOCOUNT ON;      

 

  Declare @strText as nvarchar(500)    

  select @strText = Replace(SearchText,N'^',N'')    

  from TABLENAME

  where UserName = @UserName        

    

     While PatIndex(N'%[^a-z^A-Z^0-9^А-Я^а-я^诶-贼德^一-龥 ]%', @strText) > 0   

      BEGIN   

              Set @strText = Stuff(@strText, PatIndex(N'%[^a-z^A-Z^0-9^А-Я^а-я^诶-贼德^一-龥 ]%', @strText), 1, ' ')             

       END   

            

    select @strText as UserKeyword     

      

END