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