Changing collation of t_object.Name in SQLServer

[Mauricio Moya (Arquesoft)]

Hi. We pretend to allow the EA search to find the elements (or packages, or diagrams) even when the name is not exactly wrote. In Spanish we use accents for the vowels and we need EA can find elements writing or not the accents.

For example: if we find in a Simple search "produccion" we want the same results as searching "producción".

In SQLServer it is supposed to change the collation of the column Name of table t_object (ignoring the simple search also search into Notes and alias).

After changing only the collation of the column we were unable to access the model from EA (it doesn't load in the project browser and displays an error about some UNION and the collation problem when loading the data).

The question is: do you know a better approach to get the desired behavior? Have you done something similar to this? any ideas? maybe changing all columns collation?

[skiwi]

I'm interested in the answer to this too.
Our SQL Server data has collation set to case_insensitive and accent_insensitive. But mācrons are treated differently anyway.


I guess you could add your own queries, e.g. SELECT name FROM t_objectable t_object  COLLATE Latin1_General_CI_AI WHERE ...