FTS Catalogs Set to Case Sensitive True/False

• SteveOC

  Ten Centuries

  Points: 1257

  More actions

  January 12, 2024 at 5:28 pm

  #4360894

  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.

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  January 13, 2024 at 6:10 pm

  #4361335

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• May 1, 2024 at 7:23 am

  This was removed by the editor as SPAM