Just want to make sure there is no integer data type in Firebird 1.5
to store the integer equivalent of GUID?

If no, I need to use the GUID as string to store as primary key. Yes,
my application is a sort of distributed system, ie. embedded server on
client machines.

I will generate the GUID in my application, ie. Delphi. How do I store
the GUID as CHAR(22) ?



--- In firebird-support@yahoogroups.com, Pavel Menshchikov
<developer@l...> wrote:

>
> [repost]
> Hello,
>
> a> I would like to use the GUID as primary key field.
> a> However, the BIGINT is 64 bit and it cannot be used to store GUID.
> a> What alternative data type can I use to store the GUID?
> a> If say, define the primary fieled as VARCHAR(38), is the index wide
> a> enough to do sorting or searching ?
>
> As Adam said, use CHAR. To generate GUIDs you need a UDF (uuidlib, for
> example). Note that "compact" form of a GUID (UUID, which could be
> saved as CHAR(22)) is more suitable/efficient for indexing in FB than
> a "regular" form of a GUID (which could be saved as CHAR(36) excluding
> brackets).
>
>
> --
> Best regards,
> Pavel Menshchikov
> http://www.ls-software.com
>