Case-Insensitive and Accent-Insensitive Linguistic Sorts

Operations inside a database are sensitive to the case and the accents of the characters. Sometimes you might need to perform case-insensitive or accent-insensitive comparisons.

To specify a case-insensitive or accent-insensitive sort:

• Append _CI to a TimesTen sort name for a case-insensitive sort. For example:

  BINARY_CI: accent-sensitive and case-insensitive binary sort

  GENERIC_M_CI: accent-sensitive and case-insensitive GENERIC_M sort

• Append _AI to a TimesTen sort name for an accent-insensitive and case-insensitive sort. For example:

  BINARY_AI: accent-insensitive and case-insensitive binary sort

  FRENCH_M_AI: accent-insensitive and case-insensitive FRENCH_M sort