Subject Re: [firebird-support] Domain character sets WAS: Create table NOT NULL and CHARACTER SET
Author Ivan Prenosil
> So this implies for each table, the applicable portion of the column
> definition is stored as a domain?
> Then there is definitely an error in 'The Firebird Book,' as Table 13-1
> states otherwise:
>
> Domain Attributes and Column Overrides
> Attribute Override? Notes
> CHARACTER SET Yes Can also be used to revert a column to
> database default.

You are right, there is an error in the book. The best what you should do
is to verify yourself which data are stored where:
RDB$RELATION_FIELDS ... contains definitions of table fiels
RDB$FIELDS ... contains definitions of domains


> I will have to create a new domain, and comment heavily so both domains
> refer to each other.

But to have domain that behaves differently for different columns
(if it was possible) seems like bad approach.
Can't you just convert the data in this "special" column
to the same character set as is defined for your domain ??

Ivan