SQL Anywhere uses the following rules when comparing numeric data types. The rules are examined in the order listed, and the first rule that applies is used:

- If one argument is TINYINT and the other is INTEGER, convert both to INTEGER and compare.
- If one argument is TINYINT and the other is SMALLINT, convert both to SMALLINT and compare.
- If one argument is UNSIGNED SMALLINT and the other is INTEGER, convert both to INTEGER and compare.
- If the data types of the arguments have a common super type, convert to the common super type and compare. The super types
are the final data type in each of the following lists:
- BIT » TINYINT » UNSIGNED SMALLINT » UNSIGNED INTEGER » UNSIGNED BIGINT » NUMERIC
- SMALLINT » INTEGER » BIGINT » NUMERIC
- REAL » DOUBLE
- CHAR » LONG VARCHAR
- BINARY » LONG BINARY

For example, if the two arguments are of types BIT and TINYINT, they are converted to NUMERIC.

Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |