Tore Halset <halse..vv.ntnu.no> wrote:
> Our database uses char(1) one some status columns. Should we switch to
> varchar(1)? We also have som columns with char(8) that is a id that
> always is 8 chars long. No trailing spaces. It seems a bit wasted to
> use varchar on these fields. What do you guys think?
Depends on your database and on your data size. For example, OpenBase makes
no distinction between char and varchar.
If your database makes a distinction, it's a space/performance tradeoff.
Neither one is probably significant in this day and age.
This archive was generated by hypermail 2.0.0 : Fri Sep 17 2004 - 19:24:39 EDT