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