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