Re: Picking CHAR over VARCHAR2

In addition, a varchar2 carries overhead for the length portion of the field. Granted, it is only a small portion. I generally use a char datatype for fields <= 5 chars and varchar2 for fields > 5 chars.

Doug Cowles wrote in message <36D41A43.F3E7D82B_at_bigfoot.com>...
>Char has padded space, making string matches more difficult. So why
>would I pick
>a Char over a VARCHAR2 even if it was only one character?
>
Received on Thu Feb 25 1999 - 11:23:59 CST