Data types
- Last UpdatedJan 04, 2023
- 1 minute read
- PI System
- PI SQL Client JDBC 2021
- Developer
PI SQL Client JDBC supports the following data types:
|
Name |
JDBC Type |
Java Type |
|---|---|---|
|
AnsiString |
VARCHAR |
String |
|
AnsiStringCs |
VARCHAR |
String |
|
Boolean |
BOOLEAN |
boolean |
|
DateTime |
TIMESTAMP |
java.sql.Timestamp |
|
Double |
DOUBLE |
double |
|
Guid |
OTHER |
java.util.UUID |
|
Int8 |
TINYINT |
byte |
|
Int16 |
SMALLINT |
short |
|
Int32 |
INTEGER |
int |
|
Int64 |
BIGINT |
long |
|
Single |
FLOAT |
float |
|
String |
NVARCHAR |
String |
|
StringCs |
NVARCHAR |
String |
|
TimeSpan |
OTHER |
java.time.Duration |
|
UInt8 |
SMALLINT |
short |
|
UInt16 |
INTEGER |
int |
|
UInt32 |
BIGINT |
long |
|
UInt64 |
BIGINT |
long |
|
Variant |
OTHER |
Object |