We should add a GuidFormat connector option that specifies how the Guid type is read/written.
| Option |
Description |
Char36 |
All columns of CHAR(36) are read/written as Guid using lowercase hex and hyphens. (Current default behavior.) |
Char32 |
All columns of CHAR(32) are read/written as Guid using lowercase hex without hyphens. |
Binary16 |
All columns of BINARY(16) are read/written as Guid using big-endian byte order. Matches UUID_TO_BIN(x). |
TimeSwapBinary16 |
All columns of BINARY(16) are read/written as Guid using big-endian byte order with time parts swapped. Matches UUID_TO_BIN(x,1). |
OldBinary16 |
All columns of BINARY(16) are read/written as Guid using little-endian byte order. (Current behavior when OldGuids=True.) |
None |
Guid is not supported. CHAR(36) and CHAR(32) are read/written as strings; BINARY(16) is read/written as a byte array. |
We should add a
GuidFormatconnector option that specifies how theGuidtype is read/written.Char36CHAR(36)are read/written asGuidusing lowercase hex and hyphens. (Current default behavior.)Char32CHAR(32)are read/written asGuidusing lowercase hex without hyphens.Binary16BINARY(16)are read/written asGuidusing big-endian byte order. MatchesUUID_TO_BIN(x).TimeSwapBinary16BINARY(16)are read/written asGuidusing big-endian byte order with time parts swapped. MatchesUUID_TO_BIN(x,1).OldBinary16BINARY(16)are read/written asGuidusing little-endian byte order. (Current behavior whenOldGuids=True.)NoneGuidis not supported.CHAR(36)andCHAR(32)are read/written as strings;BINARY(16)is read/written as a byte array.