ULSQLType lists the available UltraLite SQL database types used as table column types.
Constant | UltraLite Database Type |
Value |
---|---|---|
ulTypeLong | Integer |
0 |
ulTypeShort | UnsignedInteger |
1 |
ulTypeUnsignedLong | SmallInt |
2 |
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 |
ulTypeBinary | LongBinary |
13 |
ulTypeLongBinary | Numeric |
14 |
ulTypeString | (Var)Char |
15 |
ulTypeLongString | LongVarchar |
16 |
ulTypeNumeric | (Var)Binary |
17 |
ulTypeUUID | UniqueIdentifier |
18 |