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

SQL Anywhere 12.0.1 » Context-Sensitive Help » UltraLite plug-in help » UltraLite plug-in properties windows


Column Properties window: Data Type tab

This tab has the following components:

  • Built-in type   This option, which is always selected, enables you to choose a predefined data type for the column from the dropdown list. Integers, character strings, and dates are examples of predefined data types. For some of these types, you can specify size and/or scale.

    In UltraLite, the built-in type VARCHAR is the equivalent of both CHAR and VARCHAR in SQL Anywhere.

    • Size   Specifies the length of string columns, or the total number of digits to the left and right of the decimal point in the result of any decimal arithmetic for numeric columns. For numeric columns, the size is also called the precision value. See UltraLite precision creation parameter.

    • Scale   Specifies the minimum number of digits after the decimal point when an arithmetic result is truncated to the maximum precision value.

 See also