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]
