Ross Johnson ha scritto:
Franco Fornari wrote:
Hello,
about 2 weeks ago I sent a message where I pointed out a strange
(IMO) behaviour when sorting text fields in tables.
The problem is that if the field I want to sort has mixed capitalized
and not capitalized words, the sort order will be AZaz and not AaZz.
I think this is not handy, for text fields and didn't find any option
available.
Inside the archive of messages I only found a previous thread about
sorting in different languages, but this doesn't seem to be the case.
Since until now I didn't receive any reply or suggestion, perhaps
asked I something stupid? :-[
Hi Franco,
AFAIK Base converts form filter expressions into SQL queries that it
sends to the backend and I assume that the sort functions are done
similarly.
So, if you mean sorting text fields in database tables then, AFAIK,
Base is restricted to the sorting capabilities of the backend
database. That may be HSQL if you're using the native Base database
backend, or it may be PostgreSQL or Oracle etc. For example, quoting
the PostgreSQL documentation: "Character-string data is sorted
according to the locale-specific collation order that was established
when the database cluster was initialized."
Ross
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Hi Ross,
you are right. It's HSQL database that sorts text fields as AZaz. I
tried to use Access as database backend with a similar table and sorting
worked as I wanted (AaZz).
Thanks,
Franco
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
