> 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
2048
Alan