Hi Herbert,

even if this was totally correct explanation, it is still bug, isn't it
?

However, when I define the domain charset as WIN1250 (2-bytes per char),
it won't allow me to execute

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

Now it checks the string length as it should => I see this as
UNICODE_FSS related bug ...

Best regards,
Tom

Herbert.Augustiny@... wrote:

>
> Hi Tomas
>
> IB/FB does only check the byte count of an insert.
>
> Your country_code domain is defined as 2 Unicode chars. For one unicode
> char IB/FB reserves 3 bytes, in your case a total of 6 bytes. This means as
> long as the string you are inserting does not exceed 6 bytes, it will get
> inserted and even read back.
>
> The standard charset (don't know if it is US-ASCII or what) is represented
> as one byte values also in unicode strings.

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

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

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