Feedback
The following table lists the default forward data type mappings for Sybase data sources.
| Remote Typename | Remote Lower Len | Remote Upper Len | Remote Lower Scale | Remote Upper Scale | Remote Bit Data | Remote Data Operators | Federated Typename | Federated Length | Federated Scale | Federated Bit Data |
|---|---|---|---|---|---|---|---|---|---|---|
| binary | 1 | 254 | - | - | - | - | CHAR | - | - | Y |
| binary | 255 | 32672 | - | - | - | - | VARCHAR | - | - | Y |
| bit | - | - | - | - | - | - | SMALLINT | - | - | - |
| char | 1 | 254 | - | - | - | - | CHAR | - | - | N |
| char | 255 | 32672 | - | - | - | - | VARCHAR | - | - | N |
| char null (see varchar) | ||||||||||
| date | - | - | - | - | - | - | DATE | - | - | - |
| date | - | - | - | - | - | - | TIMESTAMP1 | - | - | - |
| datetime | - | - | - | - | - | - | TIMESTAMP(6) | - | - | - |
| datetimn | - | - | - | - | - | - | TIMESTAMP | - | - | - |
| decimal | 1 | 31 | 0 | 31 | - | - | DECIMAL | - | - | - |
| decimal | 32 | 38 | 0 | 38 | - | - | DOUBLE | - | - | - |
| decimaln | 1 | 31 | 0 | 31 | - | - | DECIMAL | - | - | - |
| decimaln | 32 | 38 | 0 | 38 | - | - | DOUBLE | - | - | - |
| float | - | 4 | - | - | - | - | REAL | - | - | - |
| float | - | 8 | - | - | - | - | DOUBLE | - | - | - |
| floatn | - | 4 | - | - | - | - | REAL | - | - | - |
| floatn | - | 8 | - | - | - | - | DOUBLE | - | - | - |
| image | - | - | - | - | - | - | BLOB | - | - | - |
| int | - | - | - | - | - | - | INTEGER | - | - | - |
| intn | - | - | - | - | - | - | INTEGER | - | - | - |
| money | - | - | - | - | - | - | DECIMAL | 19 | 4 | - |
| moneyn | - | - | - | - | - | - | DECIMAL | 19 | 4 | - |
| nchar | 1 | 254 | - | - | - | - | CHAR | - | - | N |
| nchar | 255 | 32672 | - | - | - | - | VARCHAR | - | - | N |
| nchar null (see nvarchar) | ||||||||||
| numeric | 1 | 31 | 0 | 31 | - | - | DECIMAL | - | - | - |
| numeric | 32 | 38 | 0 | 38 | - | - | DOUBLE | - | - | - |
| numericn | 1 | 31 | 0 | 31 | - | - | DECIMAL | - | - | - |
| numericn | 32 | 38 | 0 | 38 | - | - | DOUBLE | - | - | - |
| nvarchar | 1 | 32672 | - | - | - | - | VARCHAR | - | - | N |
| real | - | - | - | - | - | - | REAL | - | - | - |
| smalldatetime | - | - | - | - | - | - | TIMESTAMP(6) | - | - | - |
| smallint | - | - | - | - | - | - | SMALLINT | - | - | - |
| smallmoney | - | - | - | - | - | - | DECIMAL | 10 | 4 | - |
| sysname | - | - | - | - | - | - | VARCHAR | 30 | - | N |
| text | - | - | - | - | - | - | CLOB | - | - | - |
| time | - | - | - | - | - | - | TIME | - | - | - |
| timestamp | - | - | - | - | - | - | VARCHAR | 8 | - | Y |
| tinyint | - | - | - | - | - | - | SMALLINT | - | - | - |
| unichar2 | 1 | 254 | - | - | - | - | CHAR | - | - | N |
| unichar2 | 255 | 32672 | - | - | - | - | VARCHAR | - | - | N |
| unichar null (see univarchar) | ||||||||||
| univarchar2 | 1 | 32672 | - | - | - | - | VARCHAR | - | - | N |
| varbinary | 1 | 32672 | - | - | - | - | VARCHAR | - | - | Y |
| varchar | 1 | 32672 | - | - | - | - | VARCHAR | - | - | N |
| Note:
|
||||||||||