#6 Prices with decimals - does not work for me

[M. Thyroff]

Hello,

I am trying to install the checkout module for my
gallery2. I have a problem with the prices:

At first, I have configured the prices with decimal
comma - the decimal part is stored but ignored, the sum
only contains full Euro, while in the product
drop-down, the price is displayed with the decimal part
but without trailing zeros (for example, 10x15 - €7,2).

Then I changed the prices to prices with decimal point
- but after clicking "save", the prices list with
decimal comma again. The fields are updated (I have
changed the prices, too), but the points are converted
to commas. Is that due to the browsers locale (german)?
I do not know.

BTW, the shipping price at first also had a comma, the
decimal part was ignored, but after changing it to a
point, that works now.

I have not found the prices in the mysql - changing it
there might be a quick fix.

Can you help?

[matt_t]

Logged In: YES
user_id=1147428

Thanks for submitting this. As noted on the forums I had to
build the modules with a really nasty hack as Gallery's SQL
schema didn't have support for non-integer numeric storage
(see http://gallery.menalto.com/node/31185\). I will
investigate ways to make this more robust with different
decimal separators.

[M. Thyroff]

Logged In: YES
user_id=1373794

Hello,

I have been able to exchange the comma with a dot in the
sqladmin interface, now it works, but: when I enter the
admin page in the gallery, the price fields are drawn with a
comma; result probably of my browsers (OS') locale settings.
So the only way really to get that right is to configure
prices in the sqladmin interface.