Best data type for storing currency values in a MySQL database

mysql sql sqldatatypes
Brian Fisher picture Brian Fisher · Mar 10, 2009 · Viewed 185.5k times · Source

What is the best SQL data type for currency values? I'm using MySQL but would prefer a database independent type.

Answer

Kibbee picture Kibbee · Mar 10, 2009

Something like Decimal(19,4) usually works pretty well in most cases. You can adjust the scale and precision to fit the needs of the numbers you need to store. Even in SQL Server, I tend not to use "money" as it's non-standard.

Related questions

#1054 - Unknown column

I am using MySQL 5.5 and phpmyadmin 3.5.2 (provided by http://www.freewebhostingarea.com) My sql query is: INSERT INTO `example`(`id`, `name`, `password`) VALUES (1,we,5) where id is int type, name and password are varchar. but when ever inserting any value …

Read More
Integer division in MySQL

I have a MySQL table which has a product_id field (big integer) 1102330008 1102330025 1102330070 1103010009 1103010010 1103020006 ... I want to select rows which have product_id = 110301****. I tried to use this query: SELECT * FROM `product` WHERE (product_id/10000)=110301 but it does not return any …

Read More
How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More