Subject | Re: [firebird-support] Domain character sets WAS: Create table NOT NULL and CHARACTER SET |
---|---|
Author | Ivan Prenosil |
Post date | 2006-11-20T17:35:31Z |
> So this implies for each table, the applicable portion of the columnYou are right, there is an error in the book. The best what you should do
> 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.
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 domainsBut to have domain that behaves differently for different columns
> refer to each other.
(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