> This gives me an error

> Dynamic SQL Error
> -SQL error code = -204
> -Data type unknown
> -COLLATION EN_US for CHARACTER SET UTF8 is not defined

The UTF8 character set (which is introduced in Firebird 2.0) has only
2 collations:

- UCS_BASIC sorts in Unicode code-point order
- UNICODE sorts using the Unicode Collation Algorithm (UCA)

You can get a list of all character sets and their collations here:
http://www.destructor.de/firebird/charsets.htm

Collations are always related to a character set.

> Is it not possible to create utf8 columns with an arbitrary
> collation?

No.

> And if not, what is the correct way to do this? Do I have to map the
> collations to character sets as well? This would make character
> column definitions rather complex...

Yes ...


Best Regards

Stefan


--
Stefan Heymann
www.destructor.de/firebird