utf-8 uuid varbinary
Posted by: Kevin Beauchamp
Date: January 02, 2010 04:25PM

I'm generating my own 32-character UUID (ver. 4, w/o dashes) primary keys in PHP5.x. The InnoDB, tables and columns are all utf-8. Somewhere I read that I should be able to store the UUID as varbinary(16), however, unless I set the primary key column to varbinary(64), it truncates the UUID on insert. I'm assuming this is happening because utf-8 characters are double-byte.

When using self-generated UUID's, what should my column datatypes actually be for optimum speed and flexibility within the InnoDB?

Options: ReplyQuote

Written By
utf-8 uuid varbinary
January 02, 2010 04:25PM
January 03, 2010 08:11PM
February 20, 2010 08:39AM
February 20, 2010 08:58AM
February 24, 2010 07:56PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.