Subject Re: [firebird-support] Select Case Insensitive
Author Helen Borrie
At 11:55 PM 5/06/2008, you wrote:
>Hello Group,
>is it possible treat è as e, ò as o, à as a and viceversa ?
>(italian alphabet)

You mean accent-insensitive (the attribute depicted in Firebird 2/2.1 collations by the _AI_ infix convention).

The answer is Yes, if:

1. the column is defined in a character set that has an _AI_ collation available for Italian, AND
2. you include the COLLATE clause appropriately for the operation to which you want the accent-insensitivity to be applied

But you have not said anything about your database character set or how you want to use this...

For more information about the whole topic, refer to the Firebird 2.1 release notes.