> From: Paul Schmidt
> CREATE DOMAIN "D_BICHAR_31" AS VARCHAR(31)
> CHARACTER SET WIN1252 COLLATE PXW_INTL850;
>
> And a field defined thusly:
>
> DNAME D_BICHAR_31
>
> Yet I can't put 30 characters worth of data in this field, any idea as
> to why? Does the field need to be wider because of the colate
> phrase? If so does anyone know by how much?
>
> Firebird 1.0 Release Version running on windows or linux.

...

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

My database is full of such domains and it works as expected.

- Have you tried to insert data directly in ISQL ?
- Is not it possible that the error comes from some trigger ?



Ivan
http://www.volny.cz/iprenosil/interbase