Using Guids without Guid type in the database (MariaDB)

[Brianw919]

I have been working on an application for my church that uses Guids for the ID values in both the pocos and in the MariaDB (UUID datatype). I have just found out that the host I'm using does not support the version that supports the UUID datatype, and has no plans to upgrade.

I experimented with simply changing the database to a string ID (varchar(36)), but that caused an error when trying to retrieve the data.(Error parsing column). I have also read that errors occur when inserting to a varchar DB datatype, when the data in the ID field is a Guid..

What is best practice for working with Guid ID values in SimpleCRUD, when the database doesn't have a UUID datatype?

Thank you.