ODBC to RDM Data Types
The following table shows the mapping from ODBC C data types to ODBC SQL and PeopleSoft RDM data types:
RDM Type |
fSqlType |
Type |
---|---|---|
RDM_CHAR |
SQL_CHAR |
Unsigned char FAR* |
RDM_LONG_CHAR |
SQL_VARCHAR |
Unsigned char FAR* |
RDM_NUMBER, RDM_SIGNED_NUMBER |
SQL_NUMERIC |
Unsigned char FAR* |
RDM_DATE |
SQL_DATE |
Struct tag DATE_STRUCT { UWORD year; UWORD month; UWORD day; } |
RDM_TIME |
SQL_TIME |
Struct TIME_STRUCT { UWORD hour; UWORD minute; UWORD second; } |
RDM_DATETIME |
SQL_TIMESTAMP |
Struct TIMESTAMP_STRUCT { SWORD year; UWORD month; UWORD day; UWORD hour; UWORD minute; UWORD second; UWORD fraction; } |
RDM_IMAGE |
SQL_LONGVARBINARY |
Unsigned char FAR * |