Storing GUID/UUID in a Firebird database

Use the CHARdata type with a size of 16and the OCTETScharacter set. This saves the value in binary, thus saving a few bytes.

Use the following if you are trying to insert values to a GUID column using ADO .NET:-

((FbParameter)parameter).FbDbType = FbDbType.Guid;

Convert the Guid value to a string representation using the following code:-

((Guid)value).ToString("D")

• Share: