Data Type Mapping for Sybase ASE - DSS 6 | Data Source Solutions Documentation
Documentation: Data Type Mapping for Sybase ASE - DSS 6 | Data Source Solutions Documentation
Data Type Mapping for Sybase ASE
This section lists the mapping of data types for Sybase ASE.
Sybase ASE as Source
When Sybase ASE is used as a source location, following is the mapping of data types in Sybase ASE to the corresponding Data Source Solutions DSS repository data type.
| Sybase ASE | Capture Support | Repository Data Type |
|---|---|---|
| bigint | Native | bigint |
| int | Native | int |
| smallint | Native | smallint |
| tinyint | Native | tinyint |
| unsigned bigint | Native | unsigned bigint |
| unsigned int | Native | unsigned int |
| unsigned smallint | Native | unsgined smallint |
| numeric (precision, scale) | Native | numeric |
| decimal (precision, scale) | Native | decimal |
| double precision | Native | float |
| real | Native | real |
| smallmoney | Native | smallmoney |
| money | Native | money |
| smalldatetime | Native | smalldatetime |
| datetime | Native | datetime (sybase) |
| date | Native | date (sybase) |
| time | Native | time (sybase) |
| bigdatetime | Native | bigdatetime |
| bigtime | Native | bigtime |
| char(n) | Native | char |
| varchar(n) | Native | varchar (sybase) |
| unichar | Native | unichar |
| univarchar | Native | univarchar |
| nchar(n) | Native | char |
| nvarchar(n) | Native | varchar (sybase) |
| text | Native | text (sybase) |
| unitext | Native | unitext |
| binary(n) | Native | binary |
| varbinary(n) | Native | varbinary (sybase) |
| image | Native | image (sybase) |
| bit | Native | bit |
| timestamp | Native | timestamp (sybase) |
| sysname | Native1 | varchar (sybase) |
| longsysname | Native1 | varchar (sybase) |
1 - Native mapping supported since DSS 6.3.0/1
Sybase ASE as Target
When Sybase ASE is used as a target location, following is the mapping of DSS repository data types to the corresponding data type in Sybase ASE.
Text in green cell indicates the native data type of the DBMS
{% partial file="dss6/advanced-operations/data-type-mapping/sybase-ase.template.md" /%}