At 11:34 AM 29-01-02 +0100, you wrote:

>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)

Tomas,
Just for interest's sake, see what happens when you insert this:

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

Regards,
Helen


All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org
_______________________________________________________