>> RECREATE TABLE TEST_1
>> (
>> TST D_TST_DOMAIN CHARACTER SET ASCII COLLATE ASCII
>> )
>
>> How do you override the character set of a domain?
>
> You can't, and why do you want to? Your domain either defines a
> character set and then it's applied to all of its instances or it
> doesn't and the instances are free to use whatever character set they
> want.

Hmmm, I will try to explain better ... :-)

There is always only ONE instance of each domain (stored in RDB$FIELDS).
The only place where character set is stored is _domain_,
field _definitions_ (stored in RDB$RELATION_FIELDS) do _not_ have field
for storing character set, they always take it over from the domain they reference.

IOW this is not possible (with current structure of system tables):

> or it doesn't and the instances are free to use whatever character set they want.

Ivan