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

SQL Anywhere 11.0.1 » UltraLite - Database Management and Reference » UltraLite SQL Reference » UltraLite SQL elements » Data types in UltraLite

 

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