On Mar 7, 2015, at 4:12 AM, 'Louis van Alphen' lo...@nucleo.co.za
[firebird-support] firebird-support@yahoogroups.com wrote:
For storage purposes I would use normal column types, ints, whatever.
OK.
For duplicate checking, I would in the app, calculate a unique hash
from all the
I would suggest you to get the Firebird Book II, from Helen Borrie, so
far the most complete doc about Firebird in English. You can buy it
at ibphoenix.com, Amazon, etc.
Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br
On Mar 7, 2015, at 9:43 AM, brian br...@meadows.pair.com [firebird-support]
firebird-support@yahoogroups.com wrote:
Thanks folks, particularly to Ann - that bit about the way Firebird
arranges the indexes itself was the clincher. It seems difficult to
find a full manual for Firebird
On Fri, 06 Mar 2015 08:58:36 -0500, you wrote:
Thanks folks, particularly to Ann - that bit about the way Firebird
arranges the indexes itself was the clincher. It seems difficult to
find a full manual for Firebird unless I speak Russian (I don't!), all
there seems to be on the main site are
For storage purposes I would use normal column types, ints, whatever. For
duplicate checking, I would in the app, calculate a unique hash from all the
necessary fields taking part in the duplicate check. That hash goes into a
varchar column that has a unique constraint. The db engine then
Hi all,
I have volunteered to write a statistics-type program in
Lazarus/FreePascal under Linux and I need an embedded database, that
means it has to be Firebird. I've used a lot of database software
before, but never Firebird (nor Interbase, for that matter). I do NOT
want to force users to
Maybe storing it into a CHAR(22) using OCTECTS charset?
Helen's book describes octets as:
OCTETS | BINARY
Bytes which will not be interpreted as characters. Useful for storing
binary data, GUID strings, hexidecimal numbers and for correcting
string data that is causing transliteration errors.
On Mar 6, 2015, at 9:58 AM, brian br...@meadows.pair.com [firebird-support]
firebird-support@yahoogroups.com wrote:
My problem is that I must avoid duplicated records in the database,
the unique key is a complicated structure containing four 16-bit words
plus a 108-bit set of flags. The
Marco,
Maybe storing it into a CHAR(22) using OCTECTS charset?
While this will work and is the smallest storage footprint/representation.
I would recommend to sacrifice disk space and to store the key as a string
using a base 36 encoding (0-1 + A-Z) -- it makes debugging via tools much