User-defined data types and their equivalents

Unlike SQL Anywhere databases, UltraLite does not support user-defined data types. The following table lists UltraLite data type equivalents to built-in SQL Anywhere aliases:

SQL Anywhere data type UltraLite equivalent
MONEY NUMERIC(19,4)
SMALLMONEY NUMERIC(10,4)
TEXT LONG VARCHAR
XML LONG VARCHAR