UltraLite ActiveX User's Guide
UltraLite ActiveX API Reference
ULSQLType lists the available UltraLite SQL database types used as table column types.
| Constant | UltraLite Database Type | Value |
|---|---|---|
| ulTypeLong | Integer | 1 |
| ulTypeUnsignedLong | SmallInt | 2 |
| ulTypeShort | UnsignedInteger | 3 |
| ulTypeUnsignedShort | UnsignedSmallInt | 4 |
| ulTypeBig | Big | 5 |
| ulTypeUnsignedBig | UnsignedBig | 6 |
| ulTypeByte | Byte | 7 |
| ulTypeBit | Bit | 8 |
| ulTypeDateTime | Time | 9 |
| ulTypeDate | Date | 10 |
| ulTypeTime | Timestamp | 11 |
| ulTypeDouble | Double | 12 |
| ulTypeReal | Real | 13 |
| ulTypeNumeric | (Var)Binary | 14 |
| ulTypeBinary | LongBinary | 15 |
| ulTypeString | (Var)Char | 16 |
| ulTypeLongString | LongVarchar | 17 |
| ulTypeLongBinary | Numeric | 18 |