Hello,

I try to create a table with a column set to UTF8 using this
SQL-Statement:

CREATE TABLE TEST (TEST VARCHAR(100) CHARACTER SET UTF8 NOT NULL COLLATE
UNICODE);

This doesnt work, the following error is returned:

Undefined name.
Dynamic SQL Error.
SQL error code = -204.
Data type unknown.
COLLATION UNICODE for CHARACTER SET UTF8 is not defined.

According to the Information on this page
http://www.destructor.de/firebird/charsets.htm there should be a
collation UNICODE for UTF8. The other possible collation UCS_BASIC
doesnt work either.

If I use UNICODE_FSS as collation with the UTF8 column a table is
generated. But afterwards the character set and the collation are
UNICODE_FSS despite setting the character set to UTF8.

I am using the embedded version of Firebird 2 RC4 and the IBExpert
personal edititon. The database itself is set to UTF8.
How can I make it work? Is this a problem with the embedded version
only?

Thanks for all hints in advance.

Regards,
Flo