Re: [Firebird-net-provider] Guid Support

[Peter J. <pj...@wa...>]

> The question is how to use a 16-byte GUID in Firebird when the system
> itself doesn't.  In the database that I'm designing with Firebird I
> decided to reserve CHAR(16) for GUID only.  If I have a need for a
> 16-byte character representation then I'll use either VARCHAR(16) or
> CHAR(17).  In the CHAR(17) case I'm anticipating the front end to limit user
> input.

A column of "char(16) character set octets" should in theory hold
a binary GUID. 

But it is a field of research, whether all layers involved will gladly 
handle bytes of zero in this. It's worth a try.

A middle ground between binary and textual GUIDs would be to use base64 
encoded binary GUIDs, requiring 22 bytes.

Regards,
Peter Jacobi