Datatable sorting problem in the Brazilian standard of numerals

Question

I got a little problem, I bet a lot of people have been there. We know that there are several standards of formats in different countries, I’m using a plugin front-end quite known when it comes to tables, which is the datatable, and it has several features, and one of them is sorting. The standard of numerals that the datatable uses understands that thousand houses are separated by comma and decimals by point (1,000.0), while the Brazilian standard is the opposite (1,000.0). So the problem is this, when entering this information in the Brazilian standard, at the time of ordering, it orders wrong because it understands that thousand houses are decimal and vice versa.

Follows the image of the incorrect ordering:

In the image he is ordering the weight in an increasing way, and is understanding that 23,479.5 is less than 825.5 due to the positioning of the score

Can anyone tell me if there is any method that I can override the datatable plugin to adapt in the right way?

Answer 1

You need to take into account the culture that is being used when ordering anything. In the case of Datatables here are the instructions for you to sort taking into account the culture used.

https://datatables.net/examples/basic_init/comma-decimal.html`