No change in schema
- Last Updated: February 11, 2026
- 1 minute read
- OpenEdge
- Version 13.0
- Documentation
The following table identifies the datatypes when there is no change in the schema for any of the drivers:
| Data Type | OpenEdge Wire Protocol Driver | SQL Server Driver | SQL Native Client 11 Driver | ODBC Driver 18 for SQL Server |
|---|---|---|---|---|
| int | integerFOREIGN-TYPE
"INTEGER"
|
integerFOREIGN-TYPE
"INTEGER"
|
integerFOREIGN-TYPE
"INTEGER"
|
integerFOREIGN-TYPE
"INTEGER"
|
| bigint | int64
|
int64
|
int64
|
int64
|
| smallint | integer
|
integer
|
integer
|
integer
|
| tinyint | integer
|
integer
|
integer
|
integer
|
| decimal | decimal
|
decimal
|
decimal
|
decimal
|
| float | decimal
|
decimal
|
decimal
|
decimal
|
| numeric | decimal
|
decimal
|
decimal
|
decimal
|
| money | decimal
|
decimal
|
decimal
|
decimal
|
| smallmoney | decimal
|
decimal
|
decimal
|
decimal
|
| binary | character
|
character
|
character
|
character
|
| bit | logical
|
logical
|
logical
|
logical
|
| char | character
|
character
|
character
|
character
|
| varchar | character
|
character
|
character
|
character
|
| nchar | character
|
character
|
character
|
character
|
| nvarchar | character
|
character
|
character
|
character
|
| varbinary | character
|
character
|
character
|
character
|
| timestamp | character
|
character
|
character
|
character
|
FOREIGN-TYPE—Displays the foreign datatype.DSRVR-PRECISION—Displays the total number of digits in decimal fields or the precision of the field.DSRVR-SCALE—Displays the digits to the right of the decimal or the scale of the field.DSRVR-LENGTH—Displays the length of the field when represented by characters. For numbers, it defaults to the maximum limit allowed for a field.