MySQL query fields are not sorted correctly

[Edition Nehemia]

Hi Sergey,

MySQL query fields are not sorted correctly in tables if they are only numbers.
Apparently a text sort is applied, which makes perfect sense. It would be worth checking whether it is not possible to specify in the field options whether this is a pure number. This would then allow the correct sorting to be applied to each field.

I have included it under errors because it is a number field and the numbers are not sorted correctly at the moment.

Kind regards
Christoph

[Didou12]

Like : 0, 1, 10, 11, 2, 3 ?

[Edition Nehemia]

Yes, exactly!
Is there a solution?

[support]

Open phpmyadmin and change column type to Float to this field, if this field contain only numbers.
By default this filed type is string that is why it sorts as string.

So find table app_entity_X (X - is ID of entity)
And in table find column field_Y (Y - is ID of your field)

Backup first before any changes in db.

[Edition Nehemia]

THANK YOU, works perfectly!