Originally Posted by
Evertjan Dondergoor
You can go to SQL-manager and change the SQL-collate from just this one field. No scripting needed. I have a situation like this in one of my projects. It certainly has his drawbacks but it has been working for years.
You could also create a (calculated) field with the same content but a different collate.