Article:  |
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 thx, cc |
||
Showing messages 1 through 1 of 1.
