Hi,

my colleague just spotted strange behaviour and I consider this a bug.

CREATE DOMAIN COUNTRY_CODE AS CHAR(2) CHARACTER SET UNICODE_FSS NOT
NULL;
CREATE TABLE TAB_COUNTRY
(
COUNTRY COUNTRY_CODE,
NAME VARCHAR(40) CHARACTER SET UNICODE_FSS NOT NULL,
PRIMARY KEY (COUNTRY)
);

When connecting to this table via IBConsole (IBExpert or probably
anything else)
using charset UNICODE_FSS, following SQL command should not execute - it
is CHAR(2) column - but it DOES !

insert into tab_country values ('aaaaaa', 'bbbbbbbbbbbbbbbb')

We tested this on FB 0.9.4 SS for Linux, FB1 RC2 for Windows ...

Is this known bug ? (I couldn't find anything about it)

Best regards,
Tom

=================================

Tomas Michalik
ProCA, s. r. o.
V Luzich 818, Praha 4
Czech Republic

e-mail: michalik@...
tel: +420 2 67283446