Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 12.0.0 » 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
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0