Subject | varchar(2048) holds 1012 |
---|---|
Author | kyle@nevadacitysoftware.com |
Post date | 2004-01-01T00:06:47Z |
Hello,
Using FB 1.0
I have a varchar(2048) that holds only about 1012 actual characters. If I try to insert
more than that It fails with:
First Err: arithmetic exception, numeric overflow, or string truncation
SqlCode: Arithmetic overflow or division by zero has occurred.
The particular string consisted of numerals "12345670123etc", but of course that
should not make any difference.
Is this to be expected? I am pretty sure that I have other tables with varchar(2048)
which will allow inserts of 2000 chars. Or am I losing my mind :)
Thanks,
Kyle
http://pearz.com - A new whole-person approach to online dating
Using FB 1.0
I have a varchar(2048) that holds only about 1012 actual characters. If I try to insert
more than that It fails with:
First Err: arithmetic exception, numeric overflow, or string truncation
SqlCode: Arithmetic overflow or division by zero has occurred.
The particular string consisted of numerals "12345670123etc", but of course that
should not make any difference.
Is this to be expected? I am pretty sure that I have other tables with varchar(2048)
which will allow inserts of 2000 chars. Or am I losing my mind :)
Thanks,
Kyle
http://pearz.com - A new whole-person approach to online dating