Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Reference » SQL data types » Data type comparisons


Other comparisons

  1. If the data types are a mixture of CHAR (such as CHAR, VARCHAR, LONG VARCHAR, and so on, but not NCHAR types), convert to LONG VARCHAR and compare.

  2. If the data type of any argument is UNIQUEIDENTIFIER, convert to UNIQUEIDENTIFIER and compare.

  3. If the data type of any argument is a bit array (VARBIT or LONG VARBIT), convert to LONG VARBIT and compare.

  4. If one argument has CHARACTER data type and the other has BINARY data type, convert to BINARY and compare.

  5. If one argument is a CHAR type, and the other argument is an NCHAR type, use predefined inference rules.

  6. If no rule exists, convert to NUMERIC and compare.

    For example, if the two arguments have REAL and CHAR data types, they are both converted to NUMERIC.

 See also