> -----Original Message-----
> From: Helen Borrie [mailto:helebor@...]
> Sent: Miércoles 2 de Mayo de 2001 12:03
> >
> >are there advantages of one over the other method??
>
> There is some insignificant difference in storage size - it's
> largely a matter of preference.

IB will go faster with smallint columns than with char columns, at least in
my experience. No charset or collation or c string termination overhead,
etc. Only measurable with a lot of records to know what approach is faster
really.

> You would use a smallint for the 1,0 method. For a char(1) pair,
> 'T' & 'F' are more common than 'Y' and 'N' (would that be 'V' et
> 'F' en français?)

Oui, madame, V => vrai...
as in Spanish V => verdadero

C.