Natural sort in AJAX Datatables

FedericoV

I'm struggling to figure out how to set natural sort in AJAX Datatables. The MySQL table includes more then 50.000 rows...so the natural sorting should be performed on server side.
I'm wondering if there is any best practice to perform such sorting using Datatables.
I'm trying to figure out how to set the Codeigniter Active Record query properly, using binary or casting way.
Thanks a lot for any help

rf1234

https://datatables.net/examples/plug-ins/sorting_manual

list of plug ins https://datatables.net/plug-ins/sorting/

natural sorting plug in
https://datatables.net/plug-ins/sorting/natural

Just use the search field in the upper right corner of your screen please