Subject | Re: OfBiz and Firebird |
---|---|
Author | peter_jacobi.rm |
Post date | 2004-06-15T11:25:26Z |
Marcello, Lester, All,
Firebird-general@yahoogroups.com, Lester Caine <lester@l...> wrote:
[...]
with long strings which must be indexed, by using a
loadable collation which replaces the tail of the string
with a hash key:
"A long string which is unwisely be choosen as primary key"
=>
"A long str {4DF543E5}"
This will actually work, and would be invisible to the
app (if sorting only on the first N chars is good enough),
but of course it's a hack.
Regards,
Peter Jacobi
Firebird-general@yahoogroups.com, Lester Caine <lester@l...> wrote:
[...]
> The TikiWiki database has a lot of long keys because they use long[...]
> VARCHAR fields for Primary Keys.
> > Does anybody know if FB 1.5 solves this issue?On a recent similiar discussion I proposed to cope
>
> Simply copying bad design may not actually be solving a problem just
> perpetuating it ;)
with long strings which must be indexed, by using a
loadable collation which replaces the tail of the string
with a hash key:
"A long string which is unwisely be choosen as primary key"
=>
"A long str {4DF543E5}"
This will actually work, and would be invisible to the
app (if sorting only on the first N chars is good enough),
but of course it's a hack.
Regards,
Peter Jacobi