Do you understand the implications of using a string as a primary key?

Jason

Adam wrote:

> --- 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
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>

--
The information transmitted herewith is sensitive information intended only for use to the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon, this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.