Data Types
From avawiki
AVA Database data types contain numerical, non-numerical and symbol types.
| Data type | Internal Data Type representation | Range |
| FLOAT | double precision floating number | ±0.0×e−383 to ±9.9e384 |
| INT | 32 bit integer | –2,147,483,648 to 2,147,483,647 |
| UINT | 32 bit unsigned integer | 0 to 4,294,967,295 |
| LONG | 64 bit long integer | –9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 |
| CHAR | character with fixed length ( enforced ) | unbounded |
| VARCHAR | variable length character ( need to define the max allowed size/byte ) | unbounded |
| DATE | long | unbounded |
| TIME | unsigned integer ( milli-second precision ) | unbounded |
| BOOL | boolean | unbounded |
| DATETIME | double precision floating number | unbounded |
| SYMBOL | internal hash lookup of VARCHAR | unbounded |
The SYMBOL data type is a special data type attached to VARCHAR. It keeps an internal hash lookup table to keep track of VARCHAR. This data type is to enhance the performance of VARCHAR datatype. Possible usages are: country names, lists, menu options, etc. Normalized table with foreign keys on the VARCHAR will achieve similar results.
All date type conversions are compliant with SQL '92 language specifications.
