skoczian escreveu:

> 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).
>

Did you downloaded it from FB project or is it from Gentoo repositories?

Please do a ldd fbserver (for Super) or libfbembed (for Classic) to see
dependencies.

Does firebird.log have anything?


Adriano