Subject | Re: [firebird-support] Select Case Insensitive |
---|---|
Author | Helen Borrie |
Post date | 2008-06-05T23:59:06Z |
At 11:55 PM 5/06/2008, you wrote:
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.
./heLen
>Hello Group,You mean accent-insensitive (the attribute depicted in Firebird 2/2.1 collations by the _AI_ infix convention).
>is it possible treat è as e, ò as o, à as a and viceversa ?
>(italian alphabet)
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.
./heLen