SQL Server - Searching string with international characters using LIKE clause
Posted
by Nikhil
on Stack Overflow
See other posts from Stack Overflow
or by Nikhil
Published on 2010-04-07T18:21:31Z
Indexed on
2010/04/07
18:33 UTC
Read the original article
Hit count: 155
Filed under:
sql
Hi,
I have a field 'Description' which can have product descriptions with any unicode characters. If I search for a description which contains an international character, with a LIKE condition (word searched with does not have the international character) I get the following results:
Ex: GEWÜRZTRAMINER is one of the descriptions.
When I do:
Select * from table where Description LIKE '%GEWURZTRAMINER%', it retrieves the entry.
When I do:
Select * from table where Description LIKE '%GEWURZ%', the entry is not retrieved.
(Note: the search condition does not include the Ü but has a U)
Is there a way around this so that I can retrieve with '%GEWURZ%' as well?
- SQl Server 2008
© Stack Overflow or respective owner
