On Thursday, January 15, 2009, at 01:56PM, "Jim Starkey" <[email protected]> wrote: >Jay Pipes wrote: >> Roland Bouman wrote: >>> Hi! >>> >>> On Thu, Jan 15, 2009 at 9:30 PM, Brian Aker <[email protected]> wrote: >>>> I thought that this might make for a nice comparison: >>>> http://www.sqlite.org/datatype3.html >>>> >>>> Not much :) >>> >>> Indeed. I'd say...too little. >>> >>> Really - there has to be DECIMAL and DATETIME (or else DATE and >>> TIMESTAMP) >> >> Agreed, although DECIMAL in Drizzle/MySQL is really a text field... >> (shhh, don't tell anybody!) >> > >Oh, I don't think so. Better look again. It's not text, it's not >binary, and it certainly isn't pretty. It does compare naturally, though.
MySQL hasn't used plain text to store decimals for quite some time... it has had a base 10^9 representation for it's decimal type. I think it was introduced in the 4.1 era or maybe 5.0 but I cannot remember right now. Each 32bit word stores a binary number from 0 to 999999999. Regards, Antony. _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
