Is UUID without dashes/hyphens valid?

The production in RFC 4122 (section 3, page 4), defines UUID string representation as UUID = time-low “-” time-mid “-” time-high-and-version “-” clock-seq-and-reserved clock-seq-low “-” node where each internal component is hex-encoded. Therefore, f47ac10b58cc4372a5670e02b2c3d479 is not a valid UUID representation.

Is Oracle’s SYS_GUID() UUID RFC 4122 compliant?

If you want that format try this: select regexp_replace(rawtohex(sys_guid()) , ‘([A-F0-9]{8})([A-F0-9]{4})([A-F0-9]{4})([A-F0-9]{4})([A-F0-9]{12})’ , ‘\1-\2-\3-\4-\5’) as FORMATTED_GUID from dual Example Results: FORMATTED_GUID ———————————— F680233E-0FDD-00C4-E043-0A4059C654C9

How to generate a GUID in VBScript?

Function CreateGUID Dim TypeLib Set TypeLib = CreateObject(“Scriptlet.TypeLib”) CreateGUID = Mid(TypeLib.Guid, 2, 36) End Function This function will return a plain GUID, e.g., 47BC69BD-06A5-4617-B730-B644DBCD40A9. If you want a GUID in a registry format, e.g., {47BC69BD-06A5-4617-B730-B644DBCD40A9}, change the function’s last line to CreateGUID = Left(TypeLib.Guid, 38)

Storing MySQL GUID/UUIDs

From MySQL 8.0 and above you could use UUID_TO_BIN: UUID_TO_BIN(string_uuid), UUID_TO_BIN(string_uuid, swap_flag) Converts a string UUID to a binary UUID and returns the result. (The IS_UUID() function description lists the permitted string UUID formats.) The return binary UUID is a VARBINARY(16) value. CREATE TABLE t (id binary(16) PRIMARY KEY); INSERT INTO t VALUES(UUID_TO_BIN(UUID(), true)); INSERT … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)