"Claudio Valderrama C." wrote:

> Excuse my doubt, but let's assume I create a db with a specific character
> set, so all the char fields by default will pick that charset. Does this
> affect system tables?

Let's try:

CREATE DATABASE 'foo.gdb' DEFAULT CHARACTER SET iso8859_1;

SELECT R.RDB$RELATION_NAME, RF.RDB$FIELD_NAME, F.RDB$FIELD_NAME,
C.RDB$CHARACTER_SET_NAME
FROM RDB$RELATIONS R, RDB$RELATION_FIELDS RF, RDB$FIELDS F,
RDB$CHARACTER_SETS C
WHERE
R.RDB$RELATION_NAME = RF.RDB$RELATION_NAME
AND RF.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME
AND F.RDB$CHARACTER_SET_ID = C.RDB$CHARACTER_SET_ID
ORDER BY 1, 2;

In IB 4.0 and 6.0 Classic server for Linux, many of these results are
character set "NONE", and many of them are "UNICODE_FSS", regardless of
the default character set specified.

Bill