24 September 2013 by Web Bureau
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"