Subject Re: [ib-support] Re: Problem with field length
Author Helen Borrie
At 01:43 PM 11-12-01 +0100, you wrote:

>The only thing I found in the bug list was bug 222563. It relates to isql
>and others not reading the correct metadata, but shouldn't the server
>itselve check wehter an insert into its tables conforms to the declaration
>of the table?

If you declare a 30-char column in UNICODE_FSS it will be 30 unicode characters long, or 90 bytes.

If you insert 40 characters using a one-byte local character set that is not unicode, but is unicode_fss compatible, then it will fit into a 90-byte column IF the parser is comparing byte-counts instead of character counts. I agree with you, this is wrong, it should be comparing character counts, but I believe it was fixed months ago.

Would you now wait until Claudio reads this thread and he will explain all. <g>