PS 1.6.1.11 - MySQL alpha numeric / natural sorting

[lwdsmedia]

I can't imagine i'm the only one with this queston but I've searched for this and i coudlnt find a solution.

 

If i look at my product features values in BO or the filters in shop i noticed that the ordering of number isnt natural. For example this is how my feature/filter values are listed:

 

Feature: volume

Values: 

0 - 5.000

10.000 - 20.000

20.000 - 30.000

5.000 - 10.000

above 30.000

 

How or where can i change the query so the "5.000 - 10.000" comes after "0 - 5.000"?

 

By default prestashop/mysql is ordering and displaying numbers like:

1

10

11

120

2

3

31

4

 

But i want:

1

2

3

4

10

11

31

120

 

How do i accomplish that? Did i overlook a config option?

[lwdsmedia]

Help please. Can't be the only one with this question

[lwdsmedia]

bump