On Sep 12, 2006, at 9:42 PM, Phillip J. Eby wrote:
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/ ExternalInformationModelDataTypesThe leftmost column contains the types supported by application/ schema.py. The middle column could get filled in with whatever typesCosmo 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".
MySQL requires length information for CHAR and VARCHAR types - I just don't think that Morgen is including that in the table.
For numeric types like INT the optional value is used to control it's display width - the actual size stored in the database depends on the type chosen.
Full details can be found here: http://dev.mysql.com/doc/refman/5.0/en/data-types.html
--- Bear Build and Release Engineer Open Source Applications Foundation (OSAF) [EMAIL PROTECTED] http://www.osafoundation.org [EMAIL PROTECTED] http://code-bear.com PGP Fingerprint = 9996 719F 973D B11B E111 D770 9331 E822 40B3 CD29
PGP.sig
Description: This is a digitally signed message part
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Open Source Applications Foundation "chandler-dev" mailing list http://lists.osafoundation.org/mailman/listinfo/chandler-dev
