Enum ColumnType
SQL column type.
public enum ColumnType
Fields
Boolean = 1
Boolean.
SQL type:BOOLEAN
, .NET type: bool.ByteArray = 16
Byte array.
SQL type:VARBINARY
, .NET type:byte[]
.Date = 9
Timezone-free date (year, month, day).
SQL type:DATE
, .NET type: LocalDate.Datetime = 11
Timezone-free datetime (Date + Time).
SQL type:TIMESTAMP
, .NET type: LocalDateTime.Decimal = 8
Arbitrary-precision signed decimal number.
SQL type:DECIMAL
, .NET type: BigDecimal.Double = 7
64-bit double-precision floating-point number.
SQL type:DOUBLE
, .NET type: double.Duration = 18
Time interval.
SQL type: none, .NET type: Duration.Float = 6
32-bit single-precision floating-point number.
SQL type:REAL
, .NET type: float.Int16 = 3
16-bit signed integer.
SQL type:SMALLINT
, .NET type: short.Int32 = 4
32-bit signed integer.
SQL type:INTEGER
, .NET type: int.Int64 = 5
64-bit signed integer.
SQL type:BIGINT
, .NET type: long.Int8 = 2
8-bit signed integer.
SQL type:TINYINT
, .NET type: sbyte.Null = 0
Null.
Period = 17
Date interval.
SQL type: none, .NET type: Period.String = 15
String.
SQL type:VARCHAR
, .NET type: string.Time = 10
Timezone-free time (hour, minute, second, nanosecond).
SQL type:TIME
, .NET type: LocalTime.Timestamp = 12
Number of ticks since Jan 1, 1970 00:00:00.000 (with no timezone).
SQL type:TIMESTAMP WITH LOCAL TIME ZONE
, .NET type: Instant.Uuid = 13
128-bit UUID.
SQL type:UUID
, .NET type: Guid.