« Return to Thread: Trouble with decimals when connecting to MySQL natively

Trouble with decimals when connecting to MySQL natively

by Luis Felipe Marzagao/Andamentos :: Rate this Message:

Reply to Author | View in Thread

Hello:

I'm using OOo Base 3.1 and MySQL via native connector. Everything,
including relationships, seems to be working just fine.

In one table, I have a decimal column. No matter what I enter in this
field, the value always return to 0,00. In my country (pt_BR), the
defalut format for money is 0.000,00. So I can't add any amount via
Base, because when I jump to the next record, the value returns to 0,00
(on the tableview).

I can insert values with no problem via mysql client ot phpMyAdmin.

Is it a bug in the connector?

Tks a lot
Luis Felipe

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

 « Return to Thread: Trouble with decimals when connecting to MySQL natively