In Sweden we’re using a comma instead of a dot as decimal separator. I want the user to be able to Insert or Update a post in MySQL writing a comma which will be translated to a dot in MySQL. I also want the user to be presented a comma when Selecting a post in MySQL which of course is stored with a dot.
I have tried the following but can’t get it to work:
$fmt = numfmt_create(‘sv_SE’, NumberFormatter::DECIMAL );
$num = numfmt_parse($fmt, ‘1,2’);
$numstr = numfmt_format($fmt, 1234567.891234567890000);
If I Select a post from the db it is still presented with a dot separator…