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

SQL Anywhere 17 » UltraLite - Database Management and Developer Guide » UltraLite SQL reference

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 DECIMAL(19,4)
SMALLMONEY DECIMAL(10,4)
TEXT LONG VARCHAR
XML LONG VARCHAR