--- In firebird-support@yahoogroups.com, "Joerg Fischer" <jf505@...> wrote:
>
> hi,
>
> i have a firebird superserver v2.5.1 on win32, and a table with several varchar columns of different sizes. for instance,
>
> insert into INTERES (ianrede, itelefon) values ('1234567890', '123456789012345678901234567890')
>
> where ianrede is a varchar(10) and itelefon is a varchar(30) works as expected. The database is utf-8, don't know if this is related. Now the problem:
>
> insert into INTERES (ianrede, itelefon) values ('12345678901', '123456789012345678901234567890')
>
> gives a 'arithmetic overflow...' error, again just like expected.
>
> BUT
>
> insert into INTERES (ianrede, itelefon) values ('1234567890', '1234567890123456789012345678901')
>
> works! The entry ist created, and contains 31 characters in a varchar(30) row. (This results in an exception later on in a delphi component).
>
> Only
> insert into INTERES (ianrede, itelefon) values ('1234567890', '12345678901234567890123456789012')
>
> gives a 'arithmetic overflow...' error just like the sql statement with the 31 chars should do already.
>
> Is this a known problem/bug?
>
> Best regards
> Jörg
> --
> NEU: FreePhone 3-fach-Flat mit kostenlosem Smartphone!
> Jetzt informieren: http://mobile.1und1.de/?ac=OM.PW.PW003K20328T7073a
>