Subject | Re: [firebird-support] bigint = int64? |
---|---|
Author | Mark Rotteveel |
Post date | 2009-05-05T12:10:58Z |
> Hi,BIGINT, see http://www.firebirdsql.org/refdocs/langrefupd15-bigint.html
>
> We want to store 64 bit integers in a FB 2.1 database (2.5 as soon as
> it's out and tested with our ECO app).
>
> What datatype should we use?
> Also, does FB have a special GUID datatype? (I suppose char would do,Just use CHAR(16) with characterset OCTETS, you can use gen_uuid() to generate UUIDs (you have to wait for 2.5 for conversion from/to RFC4122 format.
> but it's really just a very large integer isn't it? 128 bit?)
--
Neu: GMX FreeDSL Komplettanschluss mit DSL 6.000 Flatrate + Telefonanschluss für nur 17,95 Euro/mtl.!* http://dslspecial.gmx.de/freedsl-surfflat/?ac=OM.AD.PD003K11308T4569a