Latest LQ Deal: Linux Power User Bundle
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 05-09-2004, 10:08 AM   #1
Registered: Jan 2003
Location: Belgium
Distribution: Mandrake 9.2
Posts: 475

Rep: Reputation: 30
ODBC/MySQL/OpenOffice - currency problem

Does anyone know why I can't enter currency to MySQL database?
I enter 4,90USD it returns either 5.00 or 4,00?

Last edited by linuxfond; 05-09-2004 at 05:28 PM.
Old 05-09-2004, 05:27 PM   #2
Registered: Jan 2003
Location: Belgium
Distribution: Mandrake 9.2
Posts: 475

Original Poster
Rep: Reputation: 30
Am I the only one who has this problem in this forum?
I googled for about an hour to figure out that there are some others who had the same problem.
I tried to change the field type to DECIMAL(4,2) (that's what was recommended for the currencies), but it did not solve the issue. I still get the nearest round number, and it is not ideal in book-keeping.
Please, help


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL ODBC Driver problem (with MS Windows) gd2shoe Linux - Software 4 11-14-2005 02:50 PM
MySQL ODBC driver fails when trying to add a DSN to MySQL banjoman Linux - Software 0 01-24-2005 10:59 AM
MySQL + ODBC + C programming qusestion sleepymish Programming 0 01-13-2004 10:52 AM
ODBC connection to MySQL darius Linux - Software 2 09-29-2003 07:40 PM
ODBC driver for MySql baburaj General 1 06-29-2002 11:52 AM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 10:28 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration