Kbase P43200: What are the Progress equivalent datatypes in comparison to Microsoft Access?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
GOAL:
What are the Progress equivalent datatypes in comparison to Microsoft Access?
FACT(s) (Environment):
Windows
Progress 8.x
Progress 9.x
FIX:
The following table lists the Microsoft Access data type constants, their descriptions and their Progress equivalent data types:
Constant Value Microsoft Access Data Type Progress Data Type
DB_BOOLEAN 1 True/False (non-Null) LOGICAL
DB_BYTE 2 Unsigned byte INTEGER
DB_INTEGER 3 2-byte signed integer (Integer) INTEGER
DB_LONG 4 4-byte signed integer (Long) INTEGER
DB_CURRENCY 5 8-byte signed integer (Currency) DECIMAL
DB_SINGLE 6 4-byte single-precision floating-point DECIMAL
DB_DOUBLE 7 8-byte double-precision floating-point DECIMAL
DB_DATE 8 Date/Time DATE
DB_BINARY 9 Binary data, 256 bytes maximum MEMPTR
DB_TEXT 10 ANSI text, 256 bytes max (Text) CHARACTER
DB_LONGBINARY 11 Long binary (OLE Object) MEMPTR
DB_MEMO 12 Long text (Memo) CHARACTER