Subject Re: [ib-support] OID: Double or String?
Author Helen Borrie
At 03:22 PM 28-08-02 -0500, you wrote:
>For Interbase, what data type is more efficient for
>primary keys ? double or string?

Double is not a recommended type to use for keys, because of precision
anomalies. Use a generated 64-bit integer for number keys. If you need
leading zeros, apply a Before Insert trigger to get a generated number and
massage it into the string you need to store.

Ideally, don't use a meaningful value for the PK at all.