[OSM-dev] Field lengths in Rails port

Ævar Arnfjörð Bjarmason avarab at gmail.com
Wed Jun 30 15:32:45 BST 2010


On Wed, Jun 30, 2010 at 08:11, John Smith <deltafoxtrot256 at gmail.com> wrote:
> On 30 June 2010 17:46, Andy Allan <gravitystorm at gmail.com> wrote:
>> Postgres ignores them, IIRC, since it doesn't have such a concept. I'm
>> sure one day some numbers will get too big for mysql, but hey.
>
> Doesn't MySQL support BigInt (64bit) and UUID (128bit) numbers?

Yes, but it generally handles larger types much worse than real
databases. E.g. you can't have an index for a TEXT, but you can index
VARCHAR(255) on InnoDB.




More information about the dev mailing list