Possible conversion errors when applying changes
Conversion errors might occur when Object Comparison Tool applies changes to the target due to truncation during conversion of data types. You can view the conversions that will occur, if any, in the summary conversion report.
The following conversions might result in errors:
- INTEGER to SMALLINT
- INTEGER to DECIMAL
- SMALLINT to DECIMAL
- FLOAT to SMALLINT
- FLOAT to INTEGER
- FLOAT to BIGINT
- FLOAT to DECIMAL
- DECIMAL to SMALLINT
- DECIMAL to INTEGER
- DECIMAL to DECIMAL
- DECIMAL to DATE
- DECIMAL to TIME
- DECIMAL to TIMESTAMP
- CHAR to CHAR
- CHAR to BINARY
- CHAR to VARCHAR
- CHAR to DATE
- CHAR to TIME
- CHAR to TIMESTAMP
- CHAR to SMALLINT
- CHAR to INTEGER
- CHAR to DECIMAL
- CHAR to LONGVAR
- BINARY to BINARY
- VARBINARY to VARBINARY
- VARCHAR to CHAR
- VARCHAR to VARCHAR
- VARCHAR to VARBINARY
- VARCHAR to TIME
- VARCHAR to TIMESTAMP
- VARCHAR to SMALLINT
- VARCHAR to INTEGER
- VARCHAR to DECIMAL
- VARCHAR to LONGVAR
- VARCHAR to DATE
- LONGVAR to CHAR
- LONGVAR to VARCHAR
- LONGVAR to DATE
- LONGVAR to TIME
- LONGVAR to TIMESTAMP
- LONGVAR to LONGVAR
- GRAPHIC to GRAPHIC
- GRAPHIC to VARGRAPHIC
- GRAPHIC to LONGVAR
- VARGRAPHIC to GRAPHIC
- VARGRAPHIC to LONGVAR
- VARGRAPHIC to VARGRAPHIC
- LONGVARG to GRAPHIC
- LONGVAR to VARGRAPHIC
- LONGVAR to LONGVAR
- DECFLOAT to SMALLINT
- DECFLOAT to INTEGER
- DECFLOAT to FLOAT
- DECFLOAT to DECIMAL
- DECFLOAT to BIGINT
- DATE to CHAR
- DATE to VARCHAR
- TIME to CHAR
- TIME to VARCHAR
- TIMESTAMP to CHAR
- TIMESTAMP to VARCHAR