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


Subject
Views
Written By
Posted
utf-8 uuid varbinary
5630
January 02, 2010 04:25PM
3563
January 03, 2010 08:11PM
3611
February 20, 2010 08:39AM
2929
February 20, 2010 08:58AM
2053
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.