Hi Jim,
Unlike (VAR)CHAR, numeric columns length is not relevant in Cayenne.
Since JDBC driver provided this information during reverse engineering,
it was included in the resulting model, but you can remove it safely.
> What does integer max length mean: number of bytes?
Whatever MySQL means by that. Likely a number of bytes it takes to
store one value in the DB.
Andrus
On Dec 11, 2003, at 11:29 AM, Jim Menard wrote:
> 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:52:16 EST