meta data for this page
  •  

F_UUIDCOMPR2UUID

return-compatible to function UUID_TO_GUID in uuidlib

Entrypoint uuidcompr2uuid compatible with UTF-8

Inputs/Outputs

   Input      CSTRING(250)     valid compressed UUID
   Output     CSTRING(36)      UUID with the same version of the compressed UUID

Syntax

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