Conversion of UUID from PostgreSQL to strings


I am using PostgreSQL for a database application, and I have been trying to use both PgDAC (devart) and FireDAC as delivered with Delphi 10.1 Berlin.  When I use PgDAC, everything works nicely.  Using FireDAC, things get strange. The UUID fields are not converted into strings the same way as they are in PgDAC (and other tools, such as Database Workbench).  The byte order seems to be flipped, and querying with the saved string representation (idString := guidField.AsString) of the original UUID gets me no results at all.  Have anybody else experienced this, and is there a solution other than using PgDAC?

Responses (1)
Your Reply

Please login to post a reply.........