I have two problems in the jQuery datatable.
Sort columns: The alphabetical order of one of the columns is sorting erroneously, for example from the column of account types. The Energy bill goes before the Water bill, because the word water has an accent on the first letter and the plugin understands that letters with an accent come after the unaccented ones.
I have a column that has that the data is string, but start with numbers (or not), for example 1st battalion, 2nd battalion and so on, or just string for example, infantry, mechanics, etc. When I click to sort by this column the 10th battalion comes just before the 1st battalion and the 9th battalion is last. I tried to force data from this column in PHP to be just int, but then the strings are not shown on the screen. How do I solve it? Related to this column, I have a 'hide' column with the ids of each battalion. If it were possible, I could sort through that other column when I clicked the first column. I do not know if I was clear.