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.


Regards,

Ann
www.ibphoenix.com
We have answers.