K-Rise Systems

When trying to search on a string with special characters containing diacritics using SQL, records with special characters containing diacritics are not located. for example
As displayed in the screenshot above, we're trying to search for the exact description for a record that exists in a catalog
After attempting to search for the specified description, we don't get any records as shown in the screenshot below
To fix this, we added COLLATE Latin1_General_CI_AI to resolve the issue

For example
SELECT * FROM Item_Catalog
WHERE Description like '%Sberný systém%'
COLLATE Latin1_General_CI_AI