Table of Contents

Enum ColumnType

Namespace
Apache.Ignite.Sql
Assembly
Apache.Ignite.dll

SQL column type.

[SuppressMessage("Microsoft.Naming", "CA1720:IdentifiersShouldNotContainTypeNames", Justification = "Ignite-specific SQL column type names are required.")]
[SuppressMessage("Design", "CA1027:Mark enums with FlagsAttribute", Justification = "Not a flags enum.")]
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.