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.

Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0