Alan,

Regarding the character set, I must be using the default, since I don't believe I have
explicitly set it or changed it in the last few years.

Thanks,

Kyle

On 1 Jan 2004, at 12:08, Alan McDonald wrote:

> > 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
>
>
>
>
>
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to:
> http://docs.yahoo.com/info/terms/
>
>



http://pearz.com - A new whole-person approach to online dating