Support for UUID
chez14 opened this issue · 0 comments
chez14 commented
Is it possible to add support for UUID?
References:
- MariaDB: https://mariadb.com/kb/en/uuid/
- MySQL: https://dev.mysql.com/blog-archive/storing-uuid-values-in-mysql-tables/
- To my knowledge, MySQL doesnt directly have uuid data type, but we can store them as binary with the help of
UUID_TO_BIN
andBIN_TO_UUID
functions. I'll attach some links for this notes too. - https://www.mysqltutorial.org/mysql-uuid/
- https://stackoverflow.com/a/54759433/4721245
- https://stackoverflow.com/a/48903998/4721245
- To my knowledge, MySQL doesnt directly have uuid data type, but we can store them as binary with the help of
- PostgreSQL: https://www.postgresql.org/docs/current/datatype-uuid.html
- SQL Server: https://docs.microsoft.com/en-us/sql/t-sql/data-types/uniqueidentifier-transact-sql?view=sql-server-ver16
To my knowledge, there are several version for UUID too, but I havent take a deeper look to what version they currently use and supports.
Thank you!