Special Irish characters Search SQL Issue Fada.

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"