Sorting field with accented character in tabpanel

Classic Servoy
1

Hi everyone,

I have a problem for which I see the logic, but it drives me crazy:

I have a tabpanel with first and last name fields. If I click on either one of the column headers, the display gets sorted - problem is, some of the names start with accented characters like “Capital E Acute” and get thrown at the end, which is logical since the ASCII code for accented characters is higher than the regular ones. What I would like is to see the names grouped and sorted by the same non-accented letter (in this case ‘E’).

Does anyone have a solution for this? That’s what happens when you live in Nouvelle-France :?

BTW, I chose UTF-8 when I created the db in Sybase Central, don’t know if that’s the root of my problem…

TIA,

Ben

2

I think some custom sql will solve the problem

<untested code>

Query = select pk from Table order by upper(name), upper(first)

var OrderedDataset = getdatasetbyquery (server, query,...) (look up exact syntax)

loadrecords(orderedDataset)

<untested code>

hope you get the idea. Obviously the trick is to use the backend database sqlfunctions

hth

3

Thanks Odysseus, that looks both interesting and promising. I was hoping for a way to circumvent custom-coding in this case, but it might not be possible otherwise… :(

Ben

4

Living in a country with 3 official languages learns you quite some tricks 8)

Glad it works for you