Raymond,

> > It depends on the number of bytes per character of your character set.
> >
> > From the IB 6 documentation...
> >
> > "To determine the maximum number of characters allowed in the data definition
> > statement of any multi-byte column, look up the number of bytes per
> > character in Appendix A. Then divide 32,767 (the internal byte storage
> > limit for any character datatype) by the number of bytes for each
> > character. Two-byte character sets have a character limit of 16,383 per
> > field, and a three-byte character set has a limit of 10,922 characters per
> > field."
> >
> FB 1.5 beta 3 does not allow 32767.

if you have a one byte collation then it probably should be
32765 for VARCHAR due to the extra two bytes holding the
VARCHAR length information. It's 32767 for a CHAR.

Regards,
Thomas.