[Juanma]

Good afternoon, I'm using Grocery Crud with datatables theme and I noticed that when I order by numbers the crud shows it like this:

 

• 0
• 1
• 1000
• 1001
• 1002
• 1004
• 101
• 1013
• 1014
• 102
• 1020

This is not right since I need the 100~ to show before the 1000. I saw a similar problem where dates would only be sorted by days but I found the solution in these forums so I hope that someone knows the solution for this.

 

Thanks in advance and have a good day!!

[zaang]

Is this column set as varchar in the database ? that might be the cause