--- In firebird-support@yahoogroups.com, "alanpltse" <alanpltse@y...>
wrote:

>
> I would like to use the GUID as primary key field.
> However, the BIGINT is 64 bit and it cannot be used to store GUID.
> What alternative data type can I use to store the GUID?
> If say, define the primary fieled as VARCHAR(38), is the index wide
> enough to do sorting or searching ?

IIRC, GUID is always the same length, so use CHAR instead of VARCHAR.
The index restrictions are somewhere around 250 bytes in Firebird 1.5,
and much higher in 2.0, so I don't see this as an issue.

Adam