MySQL Forums
Forum List  »  Character Sets, Collation, Unicode

Advanced Search
New Topic

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)

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Italian locale on format()
2495
Mario Bianchi Bianchi
July 23, 2014 01:25AM
Re: Italian locale on format()
1195
Rick James
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.