Monty Taylor wrote:
Roy Lyseng wrote:
Monty Taylor wrote:
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)
Good job Java... Do you know what the common type of INTEGER and
UNSIGNED INTEGER in MySQL is?
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. :)
Because Java was designed for more people than Americans and Western
Europeans?
Hrm... /me thinks about arguing the implementation point here, decides
not to.
Please note, I'm not picking on Java with the UCS-2 thing - only
pointing out that, in general, since all of your latin-1 strings are
going to grow internally in Java (and python 3, and php 6) that bumping
your int return types from 32-bit to 64-bit internally is likely not
going to be the thing that kills you if anything does.
I will pick on Java slightly for BigInteger having such an asinine
interface. And then I'll pick on Java (common first OO language in
Colleges) for having basic types like int not be actual objects, so that
when they _do_ have to interface with actual objects like BigInteger
everything goes wonky.
Thinking about folks outside of latin-1 languages? Win. Thinking that
uint64_t-sized values are a corner case? FAIL
Well, if you ever going to need that 64th bit, so...
What I am more concerned about is that INTEGER and UNSIGNED INTEGER are
overlapping values ranges, so the common type of them would be BIGINT or
DECIMAL(11,0). And the common type for BIGINT and UNSIGNED BIGINT is
DECIMAL(22,0) or something...
Roy
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
