UUID_FROM_CHAR(c) Function
The UUID_FROM_CHAR(c) function converts a UUID from its character representation into byte representation:
//
// Insert a UUID in character format into a table
//
* CREATE TABLE uuidtochar
AS
SELECT UUID_TO_CHAR(u1) AS c1 FROM uuidtable;
* SELECT c1 FROM uuidtochar;
//
// convert UUID into byte representation
//
* SELECT UUID_FROM_CHAR(c1) FROM uuidtochar;