Also, what are the case insensitive collations in firebird that are english? Is unicode_ci_ai the only one?

Would using an case insensitive collation like unicode_ci_ai affect performance?

--- In firebird-support@yahoogroups.com, "firebirdsql" <firebirdsql@...> wrote:
>
> How do I set case insensitive collation in Firebird 2.5? Do I have to recreate the tables and data? I would like to use the same collation as sql server.
>
> I tried alter character set utf8 set default collation UNICODE_CI_AI but it still not case insensitive.
>