Sorting numbers issue

art

When sorting columns with numbers, the sorting works great for the low to high but it doesn't work for the high to low. In high to low it selects the highest value beginning with '9', even though there are higher numbers present in the column.

I haven't done any kind of modding to the sorting parameters, so those should be on default. And fyi, I'm on server-side. Is this a known issue?

Screenshots from each column where the problem occurs:
http://screencast.com/t/1X8Tay9G0f
http://screencast.com/t/IJ0kF3jlhlLW
http://screencast.com/t/syYycdOhalP

allan

> I'm on server-side. Is this a known issue?

If you are using server-side processing that the sorting is done at the server, so it isn't something that DataTables itself has any control over. So I guess the question is, does your server-side script implement numeric sorting? Is it using an SQL DB with a numeric column type?

Allan

art

Thanks again, I changed the columns from 'varchar' into 'int' and it's working flawless!