On 24 Jul 2002 at 18:09, Ann W. Harrison wrote:

> At 05:21 PM 7/24/2002 -0400, Paul Schmidt wrote:
> >Dear List:
> >
> >I have a domain:
> >
> >CREATE DOMAIN "D_BICHAR_31" AS VARCHAR(31)
> >CHARACTER SET WIN1252 COLLATE PXW_INTL850;
> >
> >And a field:
> >
> >DNAME D_BICHAR_31
> >
> >Yet I can't put 30 characters worth of data in this field, any idea
> >as to why?
>
> No. But the error message might help, and the number of
> characters you CAN put into the field, and the field size
> and character length from rdb$fields. You should be able
> to store 31 characters in a varchar 31, regardless of character
> set. The collation affects the width of an index, but not
> the storage size.
>

It seems to accept 20 characters but not 21 the error message is this:

SQL Message : -802
Arithmetic overflow or division by zero has occurred..

Engine Message :
arithmetic exception, numeric overflow, or string truncation

From RDB$FIELDS

RDB$FIELD_LENGTH = 31
RDB$CHARACTER_LENGTH=31

It was string truncation that clued me into the problem. I am going to make the
domain larger, and see if that helps. I don't really care if it needs to be 41 or 51
even, just I have other similar fields and would need to boost those as well.




Paul Schmidt, President
Tricat Technologies
paul@...
www.tricattechnologies.com