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

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Reference » Using SQL » SQL data types » Data type conversions » Comparisons between data types

 

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. See Comparisons between CHAR and NCHAR.
  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.