martinthrelly wrote:

> hello there. we are considering porting a project to Firebird 2.0. the
> only stumbling block for us is regarding the uniqueidentifier data type.
>
> the project in question uses uniqueidentifiers as primary keys. this is
> because there is replication involved between different sites. i
> discovered that there is no inbuilt GUID type. so i have a couple of
> questions please:
>
> 1. what is the best way for me to implement a GUID type in Firebird 2.0?
> 2. i am guessing that if i have to manually create a GUID then it will
> be a varchar or something like that. i am concerned that there may be
> performance issues here by using such a datatype as the primary key
> index. for searching, etc.
>
> any useful feedback and additional comments on this would be most
> welcome as i have not used uniqueidentifiers with firebird before.
>

Martin,

This was discussed a lot of times here before.

There are UDF's available to provide you GUId values.

There will be no performance problem on it (at least none that you will
perceive)

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br