-----Original Message-----
From: Jim Starkey [mailto:jas@...]
Sent: Wednesday, March 29, 2000 12:34 PM
To: IB-Architect@onelist.com
Subject: RE: [IB-Architect] Syntax for case insensitive sort

Dave (and others): How many other close relatives does CASE/NOCASE
have? How many classes of collation classes should be expect?
How many flavors of case insensitivity are the French likely to
have?

-- Off hand, CASE / NO CASE -- ACCENT / NO ACCENT
KANA / NO KANA (handle equivilace of Japanese Hiragana & Katakana)

Does the collation driver mechanism currently support case changing?
If so, can a single pair of entrypoints (upcase, downcase) suffice.
If the French want separate ACCENT/NOACCENT collating sequence, can
we reasonable expect them to support two different drivers?

- The current collation driver interface has entrypoints for
toUpper, toLower, toCollationKey, and compareString
SQL UPPER() is hooked up to go into toUpper, and SQL LOWER() hasn't yet
been supported.

Dave