question

Hi Everyone -

I am working on a bi-lingual site where I have to store both English and Non-English characters in a SQL Server 2008 database.

So far I have been able to enter non-english characters (data) and retrieve/display them the same way they were entered in my site.

However, I am facing a challenge when trying to perform search using like or even = operators.

I am passing the search string the same way I capture it for the save operation and performing the search in a stored procedure using the code below which returns everything instead of just the one I am looking for.

Can anyone please point me what I am missing here? The "NAME_AMHARIC" column is of type NVARCHAR.

Thanks in advance for your help!

ALTER PROCEDURE [dbo].[sp_search_products]                    
                    
        @NAME_AMHARIC nvarchar(200) = null                    
                    
    AS BEGIN                    
                    
    SELECT product_id,p.category_id,name,name_amharic                    
                    
      FROM products p                    
      WHERE ltrim(rtrim(p.name_amharic)) = ltrim(rtrim(@NAME_amharic)) AND @NAME_AMHARIC is not null)                    
        ;                    
                    
    END