ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.


AddThis Social Bookmark Button
  SQL Data Types
Subject:   SQL Data Types
Date:   2002-05-01 09:35:18
From:   ccstompnet
On the table 'Sql Data Type Quick Reference'
the currency row, for MySQL N/A is listed...
It is true that an exact datatype is not available for MySQL in comparison to ACCESS, but the DECIMAL field/type(datatype) is available, I set up our MySQL db using the decimal(9,2) field/ type, this allows for the initial value to be 9 digits before decimal and of course 2 after the decimal point, reffer to http://www.mysql.com/doc/N/u/Numeric_types.html

1 to 1 of 1
1 to 1 of 1