Close
Menu
Want to work with us? We're on the lookout for digital experts.
We're hiring
24 September 2013
by Web Bureau
Hi,
Ran into this interesting issue the other day regarding Irish names. Basically we had a scenario in which we need our software to be able to search on the name with and without special characters. ie. "Paric" & "Paríc".
Basically it appears that a simple SQL 'Collate' change will do the trick.
SQL = "WHERE name COLLATE Latin1_General_CI_AI like '%" & strname & "%' COLLATE Latin1_General_CI_AI"
This site uses essential cookies for parts of the site to operate and have already been set. Find out more about how we use cookies and how you may delete them. You may delete cookies, but parts of the site will not work.