Brian Aker wrote: > Hi! > > On Jul 30, 2009, at 12:01 PM, Jeremy Zawodny wrote: > >> That's primary storage, right? What about indexes? > > Doubles the index size. > > One problem about uint64_t... now all languages can support it.
I believe that's: "not all languages can support it." Java, for instance, does not have unsigned types, meaning uint64_t maps to BigInteger, which is not directly compatible with other integral types. (good job Java) It also means that an INT UNSIGNED has to become a 64-bit int in Java to hold all of the values. Then again, Java translates all of your strings into ucs2 internally, so I'm thinking that the extra byte or two of int storage is probably not as much of an issue. :) Monty > Cheers, > -Brian > >> >> Jeremy >> >> On Thu, Jul 30, 2009 at 11:16 AM, Brian Moon <[email protected]> wrote: >> The thing I also found interesting was that (in INNODB anyway) the >> storage needs for a BIGINT are not really that much larger than INT. >> So, I am just using BIGINT these days anyway. I forget what the >> numeric data types for Drizzle are. Was there just INTEGER? >> >> Brian. >> -------- >> http://brian.moonspot.net/ >> >> >> On 7/30/09 1:05 PM, Brian Aker wrote: >> Hi! >> >> The plan is to implement SERIAL as a real type which would what you are >> asking for (the code for signed/unsigned was more then a little bit of a >> mess). >> >> Are you looking for an OID? >> >> Cheers, >> -Brian >> >> On Jul 30, 2009, at 9:08 AM, Tim Soderstrom wrote: >> >> I know there was a conversation about this on the list before but I >> was curious as to the outcome? I just built Drizzle from the latest >> version as of yesterday and 'int unsigned' no longer works. I know >> there was a big movement behind removing mediumint but I can't see how >> signed/unsigned would fall into that category? 2 billion is big, but 4 >> billion is a hellofalot bigger :) >> >> Just curious. >> >> Tim >> >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~drizzle-discuss >> Post to : [email protected] >> Unsubscribe : https://launchpad.net/~drizzle-discuss >> More help : https://help.launchpad.net/ListHelp >> >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~drizzle-discuss >> Post to : [email protected] >> Unsubscribe : https://launchpad.net/~drizzle-discuss >> More help : https://help.launchpad.net/ListHelp >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~drizzle-discuss >> Post to : [email protected] >> Unsubscribe : https://launchpad.net/~drizzle-discuss >> More help : https://help.launchpad.net/ListHelp >> > > > _______________________________________________ > Mailing list: https://launchpad.net/~drizzle-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~drizzle-discuss > More help : https://help.launchpad.net/ListHelp > _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
