Subject "Collation unicode for character set utf8 is not installed" - why?
Author skoczian
Hello,

using Firebird 2.1.1 in Gentoo Linux I get this error with every
SELECT query involving a column declared with collation "unicode" in
a database with default character set UTF8. No difference between
FlameRobin and isql.

"SHOW SYSTEM COLLATIONS" gives me

UCS_BASIC, CHARACTER SET UTF8, PAD SPACE, SYSTEM
UNICODE, CHARACTER SET UTF8, PAD SPACE, SYSTEM
UNICODE_FSS, CHARACTER SET UNICODE_FSS, PAD SPACE, SYSTEM
UTF8, CHARACTER SET UTF8, PAD SPACE, SYSTEM

So what is wrong here?

No comparable problem using Windows (another database, same default
character set, same collation, same server version).

Thank you for help,
Herta