I'm using binary format to store UUIDs in mysql database ( binnary(16) )
and I'm useing the following code in hibernate
@Id
@GeneratedValue(generator = "uuid")
@GenericGenerator(name = "uuid", strategy = "uuid2")
@Column( columnDefinition = "BINARY(16)", length = 16 )
private UUID id;
those generated values look different and seems as garbage values when I view in phpmyadmin
if I use UUID() function in mysql query it seems fine.
Then how to tell hibernate to use UUID() function
What is BINARY Type ?
They contain byte strings rather than character strings. This means that they have no character set, and sorting and comparison are based on the numeric values of the bytes in the values. That's why they look like garbage values
What does UUID() function create?
A UUID is designed as a number that is globally unique in space and time. Two calls to UUID() are expected to generate two different values, even if these calls are performed on two separate computers that are not connected to each other.A UUID is a 128-bit number represented by a utf8 string of five hexadecimal numbers in aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee format: That's why they are readable
UUID() function doesn't create a byte string, but a character string. so, they are very different .
