decimal separator in datatables_fr.json is not working for datatables 1.11.0

ooioo

**In datatables_fr.json the line
"decimal": ",",
is not working for sorting numbers in column
"language.decimal": ",",
is working
If I am right, maybe some other lines should be changed ?
**:

allan

It should be:

language: {
  decimal: ','
}

That appears in the French translation we have. Perhaps you can link to a page showing the issue please?

Allan

ooioo

Hi Allan
here is a page with datatables 11 and the original French.json file http://wikipanda.free.fr/datatables/sortnumeric/
and with "decimal" replaced with "language.decimal" in French.json file
http://wikipanda.free.fr/datatables/sortnumeric2/

Thanks for your help !

Pierre.

colin

That's odd as your code is working as expected here. Could you look at that, please, and see if it helps.

Cheers,

Colin

ooioo

Hi Colin,
you are using
http://cdn.datatables.net/plug-ins/9dcbecd42ad/i18n/French.json
and it is very different from the file I copy from
https://datatables.net/plug-ins/i18n/French.html
It doesn't even have a line with
"decimal": ",",

Pierre

allan

Hi Pierre,

Brilliant - thank you for the links. That let me track the issue down and I've committed the fix here. That fix will be in the nightly builds soon.

Regards,
Allan

colin

... and here it is in motion : http://live.datatables.net/tuhepewo/28/edit

Colin

ooioo

Hi,
thank you a lot to you both, french decimal separator is working like a charm with datatables 1.11.1.

I also see in french translation file :
"infoThousands": ".",
"thousands": ".",
I thought that in french thousands separator was a space.
https://www.cfmetrologie.com/fr/faq-mesure/14-maitrise-des-mesures/1131-virgule-point-point-virgule-que-dois-je-utiliser
But maybe it's controversial...

Regards,
Pierre

colin

Both IBM and Oracle agree that it's a space too! We'll take a nose and report back,

Colin

allan

We actually don't support a simple space as a thousands separator in our default number detection and it can also be used simply to separate two different numbers. We do support slim space and narrow no break spaces (which are UTF8 characters specifically designed for this sort of thing).

Maybe simple space support is something we should add...

Allan