On 25 Jul 2002 at 14:39, Martijn Tonies wrote:

> Hi Paul,
>
> > > >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:
>
> What characters are you putting in? ABCDEF...? Or special
> characters?

essentially A-Z, a-z, 0-9 and some of the ascii punctuation, like space -$.,# nothing
out of the ordinary, even the high-ascii stuff is stripped out.

> > 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
>
> A non-unicode charset, right?
>

Win1252 which is I think Windows ANSI I may change it to straight ASCII and see if
that makes a difference. As long as English is supported the client will be happy,
although French and Spanish character extensions would always be appreciated.




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