# Locale Currency format

**URL:** <https://www.ruby-forum.com/t/locale-currency-format/96944>\
**Category:** Rails I18n\
**Created:** [July 3, 2006, 5:25pm UTC](https://www.ruby-forum.com/t/locale-currency-format/96944 "2006-07-03T17:25:24Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![kadoudal](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/k/f0a364/32.png) [@kadoudal](https://www.ruby-forum.com/u/kadoudal)\
**Post date:** [July 3, 2006, 5:25pm UTC](https://www.ruby-forum.com/t/locale-currency-format/96944/1 "2006-07-03T17:25:24Z")

</div>

Thanks to Josh and Roland, we’ll be close to get full currency  
localization !

parsing with locale settings seems to be fine (at least of amount  
below billions of euros… I don’t intend to get over , I’m not Bill  
Gates !)  
if formatting with locale settings is fine for amounts below  
thousands… it’s not above :

1,245,568,45 â?¬ (\<%= product.price.format %\>  
1,245,568,45 (\<%= product.price.amount %\>

using locale settings thousand and decimal separators, it shoud be  
(France and Germany at least…)

1.245.568,45

I’d like to get into it but I am just a DB (David Bowie… beginner)

kad

---

<div class="post-metadata">

**Author:** ![kadoudal](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/k/f0a364/32.png) [@kadoudal](https://www.ruby-forum.com/u/kadoudal)\
**Post date:** [July 3, 2006, 6:44pm UTC](https://www.ruby-forum.com/t/locale-currency-format/96944/2 "2006-07-03T18:44:40Z")

</div>

Kad K. wrote:

> Thanks to Josh and Roland, we’ll be close to get full currency  
> localization !
> 
> parsing with locale settings seems to be fine (at least of amount  
> below billions of euros… I don’t intend to get over , I’m not Bill  
> Gates !)  
> if formatting with locale settings is fine for amounts below  
> thousands… it’s not above :
> 
> 1,245,568,45 â?¬ (\<%= product.price.format %\>  
> 1,245,568,45 (\<%= product.price.amount %\>
> 
> using locale settings thousand and decimal separators, it shoud be  
> (France and Germany at least…)

hmmm…  
i’m using:

Locale.set\_base\_language(‘de-DE’);  
Locale.set(‘de-DE’);

and getting this afterwards:  
999.500,00 â?¬

ok, here it is: selected FR from the db:  
select \* from globalize\_countries where code=‘FR’;  
id | code | english\_name | date\_format | currency\_format |  
currency\_code | thousands\_sep | decimal\_sep | currency\_decimal\_sep |  
number\_grouping\_scheme  
----±-----±-------------±------------±----------------±--------------±--------------±------------±---------------------±-----------------------  
73 | FR | France | | %n â?¬ | EUR  
| | | , | , |  
western  
looks like someone has forgotten to set a french thousands seperator 🙂  
do something like that in your db console:  
update globalize\_countries set thousands\_sep=’.’ where code=‘FR’;

Have fun,  
Roland