CODEWITHSUNDEEP
firebirdfirebird2.5
firebird
firebird

Reputation: 3511

firebird set case insensitive collation

How can I set case-insensitive collation for the whole database? I tried to alter character set utf8 set default collation UNICODE_CI_AI, but that does not seem to work.

Do I have to recreate the tables and data?

Database is Firebird 2.5

Upvotes: 1

Views: 1756

Answers (1)

ain
ain

Reputation: 22749

Quote from the release notes:

The character set and collation of existing columns are not affected by ALTER CHARACTER SET changes.

So yes, it seems that the best way would be to recreate the database with desired default character set and collation (and / or with explicit definitions in domains).

Upvotes: 4

Related Questions