下列的參考資料十分不錯,列出大部分用到的資料庫欄位型態,寫程式時還蠻有用的!
Databases - Field Types http://mc-computing.com/Databases/FieldTypes.html
ex:
Foxpro
Type | Size | Description |
---|---|---|
Character | 1 to 254 | |
Currency | 8 bytes | 18 significant figures, including 4 decimal places Not available in Database Explorer |
Date | 8 bytes | January 1st, 1 A.D to December 31st, 9999 A.D |
DateTime | 8 bytes | |
Logical | 1 byte | |
Variant | Can hold any type of field | |
Double | 8 bytes | +/-4.94065645841247E-324 to +/-8.9884656743115E307 13 significant figures This range does not make sense |
Numeric | 1 to 20 bytes | - .9999999999E+19 to .9999999999E+20 up to 10 significant figures (specified by the user), same as Float |
Float | 1 to 20 bytes | - .9999999999E+19 to .9999999999E+20 up to 10 significant figures (specified by the user), same as Numeric |
Integer | 4 bytes | -2,147,483,647 to 2,147,483,647 |
Integer (Autoinc) | 4 bytes | Autoincrement field |
General | 4 bytes in table | Reference to an OLE object The type is OLE in Database Explorer |
Memo | 4 bytes in table | Values may be modified depending on the language mapping Database Explorer indicates that these are actually 10 bytes each |
Memo (Binary) | 4 bytes in table | Values are not modified When the code page changes |