So CHAR(1) and CHARACTER SET NONE should be a 1 byte field.

At 01:51 PM 1/17/2004, you wrote:

>Hello Uwe (again),
>
> >> I need to store a flag value in a the smallest possible way. 1 Byte
> >> is sufficient. If I declare a fiield as VARCHAR(1) would that field
> >> be only 1 Byte is size ?
>
> > That depends on the character set. To be certain, use character set
> > OCTETS (or another 1-byte set) for the field.
>
>...and as Theo just wrote: use CHAR, not VARCHAR. VARCHAR needs 2
>extra bytes to store the length. I totally forgot to mention that!
>
>
>Grtz,
>Paul
>
>Yahoo! Groups Links
>
>To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
>To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>Your use of Yahoo! Groups is subject to:
> http://docs.yahoo.com/info/terms/