Subject RE: [firebird-support] Index on character type column: CHAR or VARCHAR ?
Author Alan McDonald
> 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.