Thanks for your time. This is my case.

I am testing Firebird 2.5 new features in UTF8 in an embedded install on
Linux.
So, i prepared my embed directory and copy files on it:
aliases.conf
bin
comidas.fbk
comidas.fdb
firebird.conf
firebird.msg
intl
libfbembed.so
libfbembed.so.2.5
libfbembed.so.2.5.0
plugins
security2.fdb
UDF
Then, opening the fbsql, i proceed from its prompt as this:
$ bin/fbsql comidas.fdb -u sysdba -p sa
Database: comidas.fdb, User: sysdba
SQL> create domain DESCRIPTION AS VARCHAR(20) CHARACTER SET UTF8
COLLATION UNICODE_CI_AI;
SQL> CREATE TABLE TTTT (TEST DESCRIPTION);
Statement failed, SQLSTATE = 22021
unsuccessful metadata update
-TTTT
-COLLATION UNICODE_CI_AI for CHARACTER SET UTF8 is not installed
I have yet checked out th RDB$COLLATIONS and i have UNICODE_CI_AI and
the database character set is UTF8.
I have tested again with other character set (ISO8859_1) and collation
ES_ES with no troubles.
As well, i tried to edit "fbintl.con" to activate it, and with the
CREATE COLLATION statement:
SQL> CREATE COLLATION TEST
CON> FOR UTF8
CON> CASE INSENSITIVE
CON> ACCENT INSENSITIVE;
Statement failed, SQLSTATE = 42000
unsuccessful metadata update
-Collation TEST not installed for character set UTF8
I use a Linux Gentoo box and firebird 2.5.0.26074.0 (SuperClassic and
embedded)


Any suggestion will be appreciated.
Thanks in advantage.











[Non-text portions of this message have been removed]