Subject RE: [firebird-support] case sensitive "order by"
Author Anton Malinovskiy
Thanks Helen

The performance of your solution is good, but unfortunately I can't change
database structure.

I've thought that there is some modifier to the "order by" clause or
something else.

Best regards,

Anton Malinovskiy


From: Helen Borrie [mailto:helebor@...]
Sent: Monday, April 11, 2005 4:20 PM
Subject: Re: [firebird-support] case sensitive "order by"

At 04:07 PM 11/04/2005 +0700, you wrote:

>Hello everybody,
> I've found that select statements like:
> select id, name
> from Human
> order by name;
> are case sensitive and the only way for case insensitive "order by" which
>I've found is select statement like:
> select id, name, upper(name)
> from Human
> order by 3;
>But this solution doesn't suit me. Is the any other solution?

A well-performing solution for case-insensitive orderings and searches is
to include a proxy column for each column you want this feature for, and
populate it with an insert and an update trigger, e.g.

create trigger pop_proxy for Human
active before insert or update as
new.proxy_name = upper(;

Index the proxy column.



Yahoo! Groups Links

* To visit your group on the web, go to:

* To unsubscribe from this group, send an email to:

* Your use of Yahoo! Groups is subject to the Yahoo!
<> Terms of Service.

[Non-text portions of this message have been removed]