MySQL Forums :: Character Sets, Collation, Unicode :: utf-8 uuid varbinary

Advanced Search

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 5585 Kevin Beauchamp 01/02/2010 04:25PM
Re: utf-8 uuid varbinary 3540 Rick James 01/03/2010 08:11PM
Re: utf-8 uuid varbinary 3592 Alaric Dailey 02/20/2010 08:39AM
Re: utf-8 uuid varbinary 2897 Alaric Dailey 02/20/2010 08:58AM
Re: utf-8 uuid varbinary 2045 Rick James 02/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.