# Sorting field with accented character in tabpanel

**URL:** <https://forum.servoy.com/t/sorting-field-with-accented-character-in-tabpanel/6158>\
**Category:** Classic Servoy\
**Created:** [June 30, 2006, 6:51pm UTC](https://forum.servoy.com/t/sorting-field-with-accented-character-in-tabpanel/6158 "2006-06-30T18:51:29Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![LOGIsoft](https://avatars.discourse-cdn.com/v4/letter/l/e36b37/32.png) [@LOGIsoft](https://forum.servoy.com/u/LOGIsoft)\
**Post date:** [June 30, 2006, 6:51pm UTC](https://forum.servoy.com/t/sorting-field-with-accented-character-in-tabpanel/6158/1 "2006-06-30T18:51:29Z")

</div>

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 ![:?]( "Confused")

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

---

<div class="post-metadata">

**Author:** ![Odysseus](https://avatars.discourse-cdn.com/v4/letter/o/cdc98d/32.png) [@Odysseus](https://forum.servoy.com/u/Odysseus)\
**Post date:** [July 2, 2006, 7:42pm UTC](https://forum.servoy.com/t/sorting-field-with-accented-character-in-tabpanel/6158/2 "2006-07-02T19:42:30Z")

</div>

I think some custom sql will solve the problem

```auto
<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

---

<div class="post-metadata">

**Author:** ![LOGIsoft](https://avatars.discourse-cdn.com/v4/letter/l/e36b37/32.png) [@LOGIsoft](https://forum.servoy.com/u/LOGIsoft)\
**Post date:** [July 3, 2006, 9:22pm UTC](https://forum.servoy.com/t/sorting-field-with-accented-character-in-tabpanel/6158/3 "2006-07-03T21:22:47Z")

</div>

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… ![:(]( "Sad")

Ben

---

<div class="post-metadata">

**Author:** ![Odysseus](https://avatars.discourse-cdn.com/v4/letter/o/cdc98d/32.png) [@Odysseus](https://forum.servoy.com/u/Odysseus)\
**Post date:** [July 4, 2006, 9:25am UTC](https://forum.servoy.com/t/sorting-field-with-accented-character-in-tabpanel/6158/4 "2006-07-04T09:25:03Z")

</div>

Living in a country with 3 official languages learns you quite some tricks ![8)]( "Cool")

Glad it works for you