The following restrictions exist when data type mapping is performed:
- If DB2 UDB mirror types GRAPHIC, VARGRAPHIC are used, the DB2 UDB mirror
database has to be created in DBCS.
- Mobile device applications must take care that the type of the data
entered into a column of a device table is compatible with the types of the
columns of the corresponding mirror and source tables and the length of the
data does not exceed the length of the corresponding mirror and source
columns. Source applications must ensure the same with data entered
into a column of a source table.
- Sybase NCHAR can be used in single-byte languages only
- Informix columns of the type DECIMAL, NVARCHAR, and VARCHAR must not be
defined using the following syntax: DECIMAL(p), NVARCHAR(m,r), and
VARCHAR(m,r).
- The following data types are not supported as primary keys by Sync
Server:
- DB2 UDB Type: LONG VARCHAR, LONG VARCHAR FOR BIT DATA,
LONG VARGRAPHIC, and VARCHAR() FOR BIT DATA
- Informix 9.x Type: DATETIME, and INTERVAL
- Oracle 8.1.7 Type: RAW
- SQL Server 2000 Type: MONEY, REAL, and SMALLMONEY
- Sybase 11.9.2 Type: BIT, DOUBLE PRECISION,
FLOAT, IMAGE, MONEY, SMALLMONEY, TEXT, and VARBINARY
- Lotus Domino Type: LONG VARCHAR