meta data for this page
  •  

F_UUID2UUIDCOMPR

return-compatible to function GUID_TO_UUID in uuidlib

Entrypoint uuid2uuidcompr compatible with UTF-8

Inputs/Outputs

   Input      CSTRING(250)     valid UUID every version
   Output     CSTRING(22)      compressed UUID

Syntax

   TestSQL (to use with TestISO.GDB)
   If you take a compressed UUID for input instead of a normal UUID:
   SELECT UUIDTESTID, 'Input no RFC4122 UUID' AS ISCORRECT, F_UUID2UUIDCOMPR(UUIDCOMPR) FROM UUIDTEST WHERE UUIDCOMPR IS NOT NULL ORDER BY 1;
   If you take a normal string for input instead of a normal UUID:
   SELECT 'Input no RFC4122 UUID' AS ISCORRECT, F_UUID2UUIDCOMPR('abcde') FROM RDB$DATABASE;
   If you take a normal UUID for input (right):
   SELECT UUIDTESTID, UUIDCOMPR AS ISCORRECT, F_UUID2UUIDCOMPR(UUID) FROM UUIDTEST WHERE UUIDCOMPR IS NOT NULL ORDER BY 1;
   SELECT NULL AS ISCORRECT, F_UUID2UUIDCOMPR(NULL) FROM RDB$DATABASE;