Subject RE: [firebird-support] varchar(2048) holds 1012
Author Alan McDonald
> 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

What character set are you using? depending on which one, you may not get
anywhere near the char size of the field. If NONE, then you should get all