I am trying to import data from an arbitrary SQL engine into a
Firebird table. Up until no,w I have been inserting the utf16 data
for character columns into VARCHAR(n) CHARACTER SET UTF8 columns and
not worrying about the collation. Collation is important,
however ;-), and I have just tried adding a COLLATE clause to the
column definition that attempt to map the collation for the incoming
column to a Firebird collation.

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

Is it not possible to create utf8 columns with an arbitrary
collation? 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...

TIA,
________________________________________________________
Richard Wesley Software Engineer
Tableau Software
http://www.tableausoftware.com/ hawkfish
tableausoftware com