Re: rtrim()

From: Mike Kienenberger (
Date: Fri Sep 17 2004 - 19:28:10 EDT

  • Next message: Bryan Dyck: "Re: very poor documentation and tutorials"

    Tore Halset <> 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