# sorting

**URL:** <https://forum.servoy.com/t/sorting/454>\
**Category:** Classic Servoy\
**Created:** [October 18, 2003, 9:20am UTC](https://forum.servoy.com/t/sorting/454 "2003-10-18T09:20:31Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![IT2Be](https://avatars.discourse-cdn.com/v4/letter/i/dc4da7/32.png) [@IT2Be](https://forum.servoy.com/u/IT2Be)\
**Post date:** [October 18, 2003, 9:20am UTC](https://forum.servoy.com/t/sorting/454/1 "2003-10-18T09:20:31Z")

</div>

Don’t know if this question should be dropped here but:

When I give in a standard sort in the properties window sorting is done with uppercase words first and lowercase after that. How can I do a sort with no regard to upper- and lowercase?

Thanks,

Marcel

---

<div class="post-metadata">

**Author:** ![Rene](https://avatars.discourse-cdn.com/v4/letter/r/7cd45c/32.png) [@Rene](https://forum.servoy.com/u/Rene)\
**Post date:** [January 2, 2004, 12:19pm UTC](https://forum.servoy.com/t/sorting/454/2 "2004-01-02T12:19:03Z")

</div>

Hello Marcel,

I get the same here ! ! ! ! ! ! ! ! ![:shock:]( "Shocked") ![:shock:]( "Shocked") ![:shock:]( "Shocked") ![:shock:]( "Shocked")

Sorting sequence is case sensitive  
First capital A-Z then Lowercase a-z  
resulting in:

Arrow up  
Button prev  
Inform  
Warning  
arrow down  
button next  
window

Is there anyone out there who found an solution for this? ? ?  
Code used:  
controller.sort(‘NAME asc, GROUP asc’)

I was kind of hoping that a # before the field would resolve it but that didn’t help either.

Rene

---

<div class="post-metadata">

**Author:** ![Jan\_Blok](https://avatars.discourse-cdn.com/v4/letter/j/41988e/32.png) [@Jan\_Blok](https://forum.servoy.com/u/Jan_Blok)\
**Post date:** [January 3, 2004, 7:22pm UTC](https://forum.servoy.com/t/sorting/454/3 "2004-01-03T19:22:37Z")

</div>

This is controlled by the database, please check your database properties

---

<div class="post-metadata">

**Author:** ![Rene](https://avatars.discourse-cdn.com/v4/letter/r/7cd45c/32.png) [@Rene](https://forum.servoy.com/u/Rene)\
**Post date:** [January 18, 2004, 9:00pm UTC](https://forum.servoy.com/t/sorting/454/4 "2004-01-18T21:00:15Z")

</div>

Hello Jan,

> Jan Blok:  
> This is controlled by the database, please check your database properties

I use the default firebird dbase engine 1.0 wich came with Servoy. How can I set these database properties??

I also have another question about sorting through a method.  
I`m storing the users actions like finds and sorts in my solution in a user settings table.  
Then I want to set the sort sequence through a variable.  
example:  
var Sort = ‘'DOCUMENT\_NUMBER asc'’ \returns ‘DOCUMENT\_NUMBER asc’  
forms..controller.sort(Sort)

Is this possible??

Also tried to place the Sort between and placing the complete function in a variable and just call the variable.

Thanks in advance Rene

---

<div class="post-metadata">

**Author:** ![maarten](https://avatars.discourse-cdn.com/v4/letter/m/ecccb3/32.png) [@maarten](https://forum.servoy.com/u/maarten)\
**Post date:** [January 18, 2004, 9:48pm UTC](https://forum.servoy.com/t/sorting/454/5 "2004-01-18T21:48:57Z")

</div>

1. 

[http://www.ibphoenix.com/a502.htm?a=ibphoenix&l=;IBPHOENIX.KNOWLEDGEBASE;ID=‘104’](http://www.ibphoenix.com/a502.htm?a=ibphoenix&l=;IBPHOENIX.KNOWLEDGEBASE;ID='104')  
According to Firebirds knowledgebase, you have to set the charset to ISO8859\_1.

1. 

No need to add the (escaped) quotes.

```auto
var Sort = 'COMPANY_NAME asc'
controller.sort(Sort)

```

---

<div class="post-metadata">

**Author:** ![IT2Be](https://avatars.discourse-cdn.com/v4/letter/i/dc4da7/32.png) [@IT2Be](https://forum.servoy.com/u/IT2Be)\
**Post date:** [January 19, 2004, 6:27am UTC](https://forum.servoy.com/t/sorting/454/6 "2004-01-19T06:27:10Z")

</div>

Wow, thank you maarten…