3. Elements of SQL Statements : SQL Functions : UUID Functions : UUID_FROM_CHAR(c) Function
 
Share this page                  
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;