meta data for this page
  •  

F_UUIDVERSION

function from adhoc

Entrypoint uuidversion compatible with UTF-8

Inputs/Outputs

   Input      CSTRING(250)     valid UUID
   Output     CSTRING(20)      (variant and) version of the UUID

Syntax

   Possible variants are: (not yet implemented)
          0    NCS (reserved for backwards compatibility)
        10    the actual variant as described in the RFC4122
      110    Microsoft (reserved for backward-compatibility)
      111    reserved for further variants
   Possible versions are:
       1    time-based
           a. with a real MAC-address described in the IEEE 802-standard
           b. with a random-generated MAC-Address described in the IEEE 802-standard
       2    DCE-security-version (with POSIX UIDs)
       3    namespace-based (with MD5)
       4    random created
       5    namespace-based (SHA-1)
   The function returns:
       V1a
       V1b
       V3
            V4
       V5
   TestSQL (für TestISO.GDB)
   SELECT ART, F_UUIDVERSION(UUID) FROM UUIDTEST ORDER BY UUIDTESTID;
   SELECT NULL AS ISCORRECT, F_UUIDVERSION(NULL) FROM RDB$DATABASE;