> In choosing between CHAR and VARCHAR to create a table with
> an index on a character type column, is there any reason why
> one should be preferred above the other and if so what is it that
> makes it the preferred one ?
>
> Thanks,
> Alain
>

if the data in the column never varies in length and is short (I use about
10 chars max) then I use CHAR to the design length of the column data.
Otherwise I use VARCHAR.
Alan