Italian locale on format()
Posted by: Mario Bianchi Bianchi
Date: July 23, 2014 01:25AM

Hi folks!
Is possible that mysql have some racist behavior against Italians, or a positive one for Deutschland?

Whereas format(float(9,2), 2, 'de_DE') return the correct number where ',' is the decimal separator and '.' is group separator, format(float(9,2), 2, 'it_IT') return the number without grouping the thousands.

- format(123456.56, 2, 'de_DE') -> 123.456,56
- format(123456.56, 2, 'it_IT') -> 123456,56

Is that a problem of mysql or my system locale? I have no clue.

mysql Ver 14.14 Distrib 5.5.38, for debian-linux-gnu (x86_64)

Options: ReplyQuote


Subject
Views
Written By
Posted
Italian locale on format()
2613
July 23, 2014 01:25AM
1252
July 24, 2014 05:23PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.