Column sorting in table

I've got a table based on a query. The query is based on a view in MySQL. When sorting the column bu clicking on the column header the column is sorted all Uppercase first and then all lowercase. How do I make the column sort regardless of case.

Presently it sorts as:

A
B
C
Z
a
b
c

Would like
A
a
B
b
C
c

etc.

Thanks
Glenn rathke

Hi Glenn,
completely untested !

TableSort(TBLXXX, Upper("+Subject") )

Bjoern

Bullshit, sorry

I think there is not much you can do on the client side.....

IMO MySQL is case-insensitive by default.
Try to declare the column with the BINARY modifier and let's see what happens

HTH, Bjoern .... tired and running out of ideas

Quote
Glenn Rathke
I've got a table based on a query. The query is based on a view in MySQL. When sorting the column bu clicking on the column header the column is sorted all Uppercase first and then all lowercase. How do I make the column sort regardless of case.

Presently it sorts as:

A
B
C
Z
a
b
c

Would like
A
a
B
b
C
c

etc.

Thanks
Glenn rathke

Hi Glenn,

once upon a time, I had to make a phone-book application and the German sorting order is even more challenging. So I translated the crucial alfa fields into sorting fields using a translation table which represented the sorting algorithm. So, the fields the user actually saw were completely different from the fields that drove the sorting.

Later on, things became more easy though, because one could associate an alfa field in Btrieve with the complete desired sorting order. You should look into the MySQL database, maybe you can define the sorting order in MySQL already. Actually there is a 'collation order' in MySQL available.

Kind regards,
Guenter

Hello Glen

In V12 there are additional sort options available for table sorting under the "sortable" tickbox in the table editor. One of the options is "ignore case"

There is also a more general purpose "sort options" function that allows you to apply the new sorting methods to some other controls.


Regards
Al



Edited 1 time(s). Last edit at 01/23/2009 04:00AM by Al.

Hi,

Yep, sure enough the optin is thdere, but not available with direct access to the file.

Thanks
Glenn