At 04:02 PM 9/12/2006 -0700, Morgen Sagen wrote:
I'm no expert in SQL data types, but does a table like this help the
discussion along?
http://wiki.osafoundation.org/bin/view/Projects/
ExternalInformationModelDataTypes
The leftmost column contains the types supported by application/
schema.py. The middle column could get filled in with whatever types
Cosmo supports. The rightmost column are guesses at some SQL types
based on the MySQL documentation.
Interesting. MySQL may be a bit unusual with respect to its data types, in
that most DB's include length information in their types, distinguishing
between say VARCHAR(4) and VARCHAR(255), or between a NUMERIC(9) and a
NUMERIC(10,2). Although it does seem that more recent databases have had
more inclination to offer some binary types like "int" and "bigint".
Is the Cosmo backend going to be MySQL?
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Open Source Applications Foundation "chandler-dev" mailing list
http://lists.osafoundation.org/mailman/listinfo/chandler-dev
