Subject varchar(2048) holds 1012
Author kyle@nevadacitysoftware.com
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