Problem with MySQL Column Type

Hi Djulia,

MySQL is dropping your fraction. The MySQL DECIMAL column type should be defined with "precision" and "scale". For example: DECIMAL(10,2)

From the MySQL docs:

When declaring a DECIMAL or NUMERIC column, the precision and scale can be (and usually is) specified; for example:

salary DECIMAL(5,2)

In this example, 5 is the precision and 2 is the scale. The precision represents the number of significant digits that are stored for values, and the scale represents the number of digits that can be stored following the decimal point. If the scale is 0, DECIMAL and NUMERIC values contain no decimal point or fractional part.

Standard SQL requires that the salary column be able to store any value with five digits and two decimals. In this case, therefore, the range of values that can be stored in the salary column is from -999.99 to 999.99.

In standard SQL, the syntax DECIMAL(M) is equivalent to DECIMAL(M,0). Similarly, the syntax DECIMAL is equivalent to DECIMAL(M,0), where the implementation is allowed to decide the value of M. MySQL supports both of these variant forms of the DECIMAL and NUMERIC syntax. The default value of M is 10.

Hi [font "Verdana"]Chris,

Thanks for your answer. :)

> [font "Verdana"]DECIMAL(10,2)
That corrected my problem !

Djulia

Hi Chris,

Which is best MySQL column type for IP address according to you ?

Thanks for your assistance.

Djulia

Hi Chris,

I think that I found an answer (BIGINT), ip2long(), long2ip().

It is an interesting article :
http://bafford.com/2009/03/09/mysql-performance-benefits-of-storing-integer-ip-addresses/

Djulia

Djulia,

Glad you got it figured out, and thanks for posting the link! :)

Hi Will,

It would depend. What are you trying to do?