Version v1.5 of the documentation is no longer actively maintained. The site that you are currently viewing is an archived snapshot. For up-to-date documentation, see the latest version.

Dialects

Overview

Dialects absorb differences in databases and drivers. A typical function of dialects is to resolve the type mappings between Kotlin and databases.

The classes representing dialects are contained in separate modules (artifacts), and the choice of which module to use must be based on the destination database and connectivity type.

Database	Type	Artifact ID	Dialect Class
H2 Database Engine	JDBC	komapper-dialect-h2-jdbc	H2JdbcSqlDialect
H2 Database Engine	R2DBC	komapper-dialect-h2-r2dbc	H2R2dbcSqlDialect
MariaDB	JDBC	komapper-dialect-mariadb-jdbc	MariaDbJdbcDialect
MySQL	JDBC	komapper-dialect-mysql-jdbc	MySqlJdbcDialect
Oracle Database	JDBC	komapper-dialect-oracle-jdbc	OracleJdbcDialect
Oracle Database	R2DBC	komapper-dialect-oracle-r2dbc	OracleR2dbcDialect
PostgreSQL	JDBC	komapper-dialect-postgresql-jdbc	PostgreSqlJdbcDialect
PostgreSQL	R2DBC	komapper-dialect-postgresql-r2dbc	PostgreSqlR2dbcDialect
SQL Server	JDBC	komapper-dialect-sqlserver-jdbc	SqlServerJdbcDialect
SQL Server	R2DBC	komapper-dialect-sqlserver-r2dbc	SqlServerR2dbcDialect

To use a dialect, specify the Artifact ID above in the Gradle dependencies declaration.

val komapperVersion: String by project
dependencies {
    implementation("org.komapper:komapper-dialect-h2-jdbc:$komapperVersion")
}

H2 - JDBC

The following table shows the data type mapping:

Kotlin Type	Database Type
java.math.BigDecimal	NUMERIC
java.math.BigInteger	NUMERIC
java.sql.Array	ARRAY
java.sql.Blob	BLOB
java.sql.Clob	CLOB
java.sql.NClob	CLOB
java.sql.SQLXML	CLOB
java.time.Instant	TIMESTAMP WITH TIME ZONE
java.time.LocalDate	DATE
java.time.LocalDateTime	TIMESTAMP
java.time.LocalTime	TIME
java.time.OffsetDateTime	TIMESTAMP WITH TIME ZONE
java.util.UUID	UUID
kotlin.Any	JAVA_OBJECT
kotlin.Boolean	BOOLEAN
kotlin.Byte	TINYINT
kotlin.ByteArray	BINARY
kotlin.Double	DOUBLE
kotlin.Float	REAL
kotlin.Int	INT
kotlin.Long	BIGINT
kotlin.Short	SMALLINT
kotlin.String	VARCHAR
kotlin.UByte	SMALLINT
kotlin.UInt	BIGINT
kotlin.UShort	INT
kotlinx.datetime.Instant	TIMESTAMP WITH TIME ZONE
kotlinx.datetime.LocalDate	DATE
kotlinx.datetime.LocalDateTime	TIMESTAMP
enum class	VARCHAR

H2 - R2DBC

The following table shows the data type mapping:

Kotlin Type	Database Type
io.r2dbc.spi.Blob	BLOB
io.r2dbc.spi.Clob	CLOB
java.math.BigDecimal	NUMERIC
java.math.BigInteger	NUMERIC
java.time.Instant	TIMESTAMP WITH TIME ZONE
java.time.LocalDate	DATE
java.time.LocalDateTime	TIMESTAMP
java.time.LocalTime	TIME
java.time.OffsetDateTime	TIMESTAMP WITH TIME ZONE
java.util.UUID	UUID
kotlin.Any	N/A
kotlin.Boolean	BOOLEAN
kotlin.Byte	TINYINT
kotlin.ByteArray	BINARY
kotlin.Double	DOUBLE
kotlin.Float	REAL
kotlin.Int	INT
kotlin.Long	BIGINT
kotlin.Short	SMALLINT
kotlin.String	VARCHAR
kotlin.UByte	SMALLINT
kotlin.UInt	BIGINT
kotlin.UShort	INT
kotlinx.datetime.Instant	TIMESTAMP WITH TIME ZONE
kotlinx.datetime.LocalDate	DATE
kotlinx.datetime.LocalDateTime	TIMESTAMP
enum class	VARCHAR

MariaDB - JDBC

The following table shows the data type mapping:

Kotlin Type	Database Type
java.math.BigDecimal	DECIMAL
java.math.BigInteger	DECIMAL
java.sql.Array	N/A
java.sql.Blob	BLOB
java.sql.Clob	TEXT
java.sql.NClob	TEXT
java.sql.SQLXML	TEXT
java.time.Instant	TIMESTAMP
java.time.LocalDate	DATE
java.time.LocalDateTime	DATETIME
java.time.LocalTime	TIME
java.time.OffsetDateTime	TIMESTAMP
java.util.UUID	N/A
kotlin.Any	N/A
kotlin.Boolean	BIT(1), BOOLEAN
kotlin.Byte	TINYINT
kotlin.ByteArray	VARBINARY
kotlin.Double	DOUBLE
kotlin.Float	FLOAT
kotlin.Int	INT
kotlin.Long	BIGINT
kotlin.Short	SMALLINT
kotlin.String	VARCHAR
kotlin.UByte	SMALLINT
kotlin.UInt	BIGINT
kotlin.UShort	INT
kotlinx.datetime.Instant	TIMESTAMP
kotlinx.datetime.LocalDate	DATE
kotlinx.datetime.LocalDateTime	DATETIME
enum class	VARCHAR

MySQL - JDBC

The following table shows the data type mapping:

Kotlin Type	Database Type
java.math.BigDecimal	DECIMAL
java.math.BigInteger	DECIMAL
java.sql.Array	N/A
java.sql.Blob	BLOB
java.sql.Clob	TEXT
java.sql.NClob	TEXT
java.sql.SQLXML	TEXT
java.time.Instant	TIMESTAMP
java.time.LocalDate	DATE
java.time.LocalDateTime	DATETIME
java.time.LocalTime	TIME
java.time.OffsetDateTime	TIMESTAMP
java.util.UUID	N/A
kotlin.Any	N/A
kotlin.Boolean	BIT(1), BOOLEAN
kotlin.Byte	TINYINT
kotlin.ByteArray	VARBINARY
kotlin.Double	DOUBLE
kotlin.Float	FLOAT
kotlin.Int	INT
kotlin.Long	BIGINT
kotlin.Short	SMALLINT
kotlin.String	VARCHAR
kotlin.UByte	SMALLINT
kotlin.UInt	BIGINT
kotlin.UShort	INT
kotlinx.datetime.Instant	TIMESTAMP
kotlinx.datetime.LocalDate	DATE
kotlinx.datetime.LocalDateTime	DATETIME
enum class	VARCHAR

Oracle - JDBC

The following table shows the data type mapping:

Kotlin Type	Database Type
java.math.BigDecimal	NUMBER
java.math.BigInteger	NUMBER
java.sql.Array	N/A
java.sql.Blob	BLOB
java.sql.Clob	CLOB
java.sql.NClob	N/A
java.sql.SQLXML	N/A
java.time.Instant	TIMESTAMP WITH TIME ZONE
java.time.LocalDate	DATE
java.time.LocalDateTime	TIMESTAMP
java.time.LocalTime	TIME
java.time.OffsetDateTime	TIMESTAMP WITH TIME ZONE
java.util.UUID	N/A
kotlin.Any	N/A
kotlin.Boolean	NUMBER
kotlin.Byte	NUMBER
kotlin.ByteArray	RAW
kotlin.Double	FLOAT
kotlin.Float	FLOAT
kotlin.Int	NUMBER
kotlin.Long	NUMBER
kotlin.Short	NUMBER
kotlin.String	VARCHAR2
kotlin.UByte	NUMBER
kotlin.UInt	NUMBER
kotlin.UShort	NUMBER
kotlinx.datetime.Instant	TIMESTAMP WITH TIME ZONE
kotlinx.datetime.LocalDate	DATE
kotlinx.datetime.LocalDateTime	TIMESTAMP
enum class	VARCHAR2

Oracle - R2DBC

The following table shows the data type mapping:

Kotlin Type	Database Type
io.r2dbc.spi.Blob	BLOB
io.r2dbc.spi.Clob	CLOB
java.math.BigDecimal	NUMBER
java.math.BigInteger	NUMBER
java.time.Duration	INTERVAL DAY TO SECOND
java.time.Instant	TIMESTAMP WITH TIME ZONE
java.time.LocalDate	DATE
java.time.LocalDateTime	TIMESTAMP
java.time.LocalTime	TIME
java.time.Period	INTERVAL YEAR TO MONTH
java.time.OffsetDateTime	TIMESTAMP WITH TIME ZONE
java.util.UUID	N/A
kotlin.Any	N/A
kotlin.Boolean	NUMBER
kotlin.Byte	NUMBER
kotlin.ByteArray	RAW
kotlin.Double	FLOAT
kotlin.Float	FLOAT
kotlin.Int	NUMBER
kotlin.Long	NUMBER
kotlin.Short	NUMBER
kotlin.String	VARCHAR2
kotlin.UByte	NUMBER
kotlin.UInt	NUMBER
kotlin.UShort	NUMBER
kotlinx.datetime.Instant	TIMESTAMP WITH TIME ZONE
kotlinx.datetime.LocalDate	DATE
kotlinx.datetime.LocalDateTime	TIMESTAMP
enum class	VARCHAR2

PostgreSQL - JDBC

The following table shows the data type mapping:

Kotlin Type	Database Type
java.math.BigDecimal	numeric, decimal
java.math.BigInteger	numeric, decimal
java.sql.Array	array of data type
java.sql.Blob	N/A
java.sql.Clob	N/A
java.sql.NClob	N/A
java.sql.SQLXML	xml
java.time.Instant	timestamp with time zone
java.time.LocalDate	date
java.time.LocalDateTime	timestamp
java.time.LocalTime	time
java.time.OffsetDateTime	timestamp with time zone
java.util.UUID	uuid
kotlin.Any	N/A
kotlin.Boolean	boolean, bool
kotlin.Byte	smallint
kotlin.ByteArray	bytea
kotlin.Double	double precision, float8
kotlin.Float	real
kotlin.Int	integer, int, int4, serial
kotlin.Long	bigint, int8, bigserial, serial8
kotlin.Short	smallint, int2, smallserial, serial2
kotlin.String	character varying, varchar, text
kotlin.UByte	smallint, int2, smallserial, serial2
kotlin.UInt	bigint, int8, bigserial, serial8
kotlin.UShort	integer, int, int4, serial
kotlinx.datetime.Instant	timestamp with time zone
kotlinx.datetime.LocalDate	date
kotlinx.datetime.LocalDateTime	timestamp
enum class	character varying, varchar, text

PostgreSQL - R2DBC

The following table shows the data type mapping:

Kotlin Type	Database Type
io.r2dbc.postgresql.codec.Interval	interval
io.r2dbc.postgresql.codec.Json	json, jsonb
io.r2dbc.spi.Blob	bytea
io.r2dbc.spi.Clob	text
java.math.BigDecimal	numeric, decimal
java.math.BigInteger	numeric, decimal
java.time.Instant	timestamp with time zone
java.time.LocalDate	date
java.time.LocalDateTime	timestamp
java.time.LocalTime	time
java.time.OffsetDateTime	timestamp with time zone
java.util.UUID	uuid
kotlin.Any	N/A
kotlin.Array	array of data type
kotlin.Boolean	boolean, bool
kotlin.Byte	smallint
kotlin.ByteArray	bytea
kotlin.Double	double precision, float8
kotlin.Float	real
kotlin.Int	integer, int, int4, serial
kotlin.Long	bigint, int8, bigserial, serial8
kotlin.Short	smallint, int2, smallserial, serial2
kotlin.String	character varying, varchar, text
kotlin.UByte	smallint, int2, smallserial, serial2
kotlin.UInt	bigint, int8, bigserial, serial8
kotlin.UShort	integer, int, int4, serial
kotlinx.datetime.Instant	timestamp with time zone
kotlinx.datetime.LocalDate	date
kotlinx.datetime.LocalDateTime	timestamp
enum class	character varying, varchar, text

SQL Server - JDBC

The following table shows the data type mapping:

Kotlin Type	Database Type
java.math.BigDecimal	decimal
java.math.BigInteger	decimal
java.sql.Array	N/A
java.sql.Blob	varbinary(max)
java.sql.Clob	text
java.sql.NClob	N/A
java.sql.SQLXML	xml
java.time.Instant	datetimeoffset
java.time.LocalDate	date
java.time.LocalDateTime	datetime2
java.time.LocalTime	time
java.time.OffsetDateTime	datetimeoffset
java.util.UUID	N/A
kotlin.Any	N/A
kotlin.Boolean	bit
kotlin.Byte	smallint, tinyint
kotlin.ByteArray	varbinary
kotlin.Double	float
kotlin.Float	real
kotlin.Int	int
kotlin.Long	bigint
kotlin.Short	smallint
kotlin.String	varchar, nvarchar
kotlin.UByte	smallint
kotlin.UInt	bigint
kotlin.UShort	int
kotlinx.datetime.Instant	datetimeoffset
kotlinx.datetime.LocalDate	date
kotlinx.datetime.LocalDateTime	datetime2
enum class	varchar, nvarchar

SQL Server - R2DBC

The following table shows the data type mapping:

Kotlin Type	Database Type
io.r2dbc.spi.Blob	varbinary(max)
io.r2dbc.spi.Clob	text
java.math.BigDecimal	decimal
java.math.BigInteger	decimal
java.time.Instant	datetimeoffset
java.time.LocalDate	date
java.time.LocalDateTime	datetime2
java.time.LocalTime	time
java.time.OffsetDateTime	N/A
java.util.UUID	N/A
kotlin.Any	N/A
kotlin.Boolean	bit
kotlin.Byte	smallint, tinyint
kotlin.ByteArray	varbinary
kotlin.Double	float
kotlin.Float	real
kotlin.Int	int
kotlin.Long	bigint
kotlin.Short	smallint
kotlin.String	varchar, nvarchar
kotlin.UByte	smallint
kotlin.UInt	bigint
kotlin.UShort	int
kotlinx.datetime.Instant	datetimeoffset
kotlinx.datetime.LocalDate	date
kotlinx.datetime.LocalDateTime	datetimev
enum class	varchar, nvarchar

Last modified June 12, 2022: Add data-type.md (e6e16c4)