I understand what the setting means for Collation Sequences and the impact it has on Indexes and in Search.
We have a number of FTS catalogs with some set to TRUE and some set to False.
What I am looking for is a way to query the Indexed Table Columns in the catalogs to see if any of the data contains Diacritical characters (it shouldn't but I want to verify this).
I have not found an easy way to do this - do I need to find all of the possible accent characters and search each data column against a list of these using varbinary or something - or is there an easier way to do this?
TIA
Steve O.