Subject | "Collation unicode for character set utf8 is not installed" - why? |
---|---|
Author | skoczian |
Post date | 2008-08-06T17:50:57Z |
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
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