Integer length

From: Jim Menard (jim..o.com)
Date: Thu Dec 11 2003 - 11:29:40 EST

  • Next message: Andrus Adamchik: "Re: Integer length"

    When I originally reverse-engineered my database, all of the integer
    columns had their max length set to 4 in Cayenne. Is this desirable? Is
    it necessary?

    What does integer max length mean: number of bytes? It is possible
    (though not very likely) that some of my tables might hold more than
    2^32 records.

    Should I remove the max lengths, or perhaps set them to 8?

    BTW, I'm using PostgreSQL now but the originally reverse-engineered
    database was MySQL.

    Thank you for your help.

    Jim 

    -- 
Jim Menard, jim..o.com, http://www.io.com/~jimm/
"T-shirts are the computer industry's only persistent objects."
     -- Seen in R. L. Peskin's .sig

    This archive was generated by hypermail 2.0.0 : Thu Dec 11 2003 - 11:29:46 EST