0

I am searching for results WHERE name LIKE '%Soucek%' (or I tried '%Souček%' or '%Soućek%'. I get one result. (I set the whole column to be COLLATE SQL_Latin1_General_CP1251_CI_AS). If I search for '%Sou_ek%' i get all results there are. I dont understand what is going on. Do you have an idea?

Jakub Bares
  • 159
  • 1
  • 11
  • In which environment is the query executed? It may be that the environment distorts the accent and sends the wrong query. Can you show results for both queries? – basic Jan 21 '20 at 20:20

1 Answers1

1

Consider using AI : "Accent Insensitive" instead of AS : "Accent Sensitive".

Also, make sure that both sides have the same collation to avoid errors or further coercions :

WHERE name COLLATE Latin1_General_CI_AI Like '%Soucek%' COLLATE Latin1_General_CI_AI
jbertrand
  • 128
  • 9