Subject | Re: [ib-support] Firebird VARCHAR size |
---|---|
Author | Raymond Kennington |
Post date | 2003-03-11T00:09:27Z |
Helen Borrie wrote:
--
Raymond Kennington
Programming Solutions
W2W Team B
>FB 1.5 beta 3 does not allow 32767.
> At 02:37 PM 10/03/2003 -0800, you wrote:
> >I'm having trouble finding docs for Firebird additions and changes to
> >Interbase. Does anyone know where I can find the maximum size of a
> >VARCHAR?
>
> 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."
>
--
Raymond Kennington
Programming Solutions
W2W Team B