See comments inline, please...
Daniel John Debrunner escreveu:
Rick Hillegas wrote:
Dan's workaround is very useful and Øyvind's suggestion is interesting
also. It's worth pointing out that the need for these workarounds should
decrease after we fix bug 533 (the re-enabling of the natonal character
datatypes). I hope to get to that bug in 10.2. The national character
datatypes will give us language-sensitive collation in indexes and sorts.
Thats sounds great! A must have for us, at latin american coutries...
Exactly, this is a workaround to help users with 10.1.
That's great you are looking at national character types for 10.2. Even
with national characters this functionality is useful because it allows
sort orders per statement, and on non-national character types. Though
there are probably advantages to building the functionality into the engine.
Dan.
Probably, the most important are that using large tables with "order by
SOME_FUNCTION(some_col)" could not be optimized unless you could index
as "create index IDX_SOMETHING on MY_TABLE (SOME_FUNCTION(some_col))"
too... Could Derby create and use indexes based on functions computing?
I think using national character datatypes will give that kind of
optimization, don't?
Best regards,
Edson Richter
begin:vcard
fn:Edson Carlos Ericksson Richter
n:Richter;Edson
org;quoted-printable:MGR Inform=C3=A1tica Ltda;Desenvolvimento
adr:Cristo Redentor;;Assis Brasil, 3257, Sala 409;Porto Alegre;RS;91010007;Brasil
email;internet:[EMAIL PROTECTED]
title:Diretor de Sistemas
tel;work:(51)3347-0446
tel;cell:(51)9259-2993
x-mozilla-html:FALSE
url:http://www.mgrinformatica.com.br
version:2.1
end:vcard
