[Chandler-dev] Sharing API type system meeting

[Mike Taylor]

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/ 
>> 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".

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)
bear at osafoundation.org
http://www.osafoundation.org

bear at code-bear.com
http://code-bear.com

PGP Fingerprint = 9996 719F 973D B11B E111  D770 9331 E822 40B3 CD29


-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 186 bytes
Desc: This is a digitally signed message part
Url : http://lists.osafoundation.org/pipermail/chandler-dev/attachments/20060912/99b7d96e/PGP.pgp