|
From: Dalton C. <dal...@gm...> - 2023-11-30 18:01:51
|
We have had the ability to store a UUID and the ability to convert the stored values to binary or character values depending upon what is needed, but, why don't we have a simple native UUID datatype? For client tools, if you store the data as binary, they display the binary as what ever default characterset is being used. So you need to wrap the data in views to make it human readable. If you store it as text, the data size increases and the speed of querying decreases. So, a simple UUID datatype that client tools such as DBeaver or flamerobin can understand to be displayed as characters for users but stored as binary on disk would make life easier for us end users trying to get people to use firebird. Is there a reason that it has not been put into place? |