Menu

Want to work with us? We're on the lookout for a talented Digital Project Manager.

We're hiring

Special Irish characters Search SQL Issue Fada.

Web Bureau


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"

 

 

 

Grow your businessStart a project with us today.