CitextColumnType

citext.kt

/**
 * Case Insensitive column type for Postgres.
 */
open class CitextColumnType : ColumnType() {
    override fun sqlType(): String = "citext"

    override fun readObject(rs: ResultSet, index: Int): Any? = rs.getBytes(index).decodeToString()

    override fun valueFromDB(value: Any): Any = when (value) {
        is Blob -> value.binaryStream.use { it.readBytes() }.decodeToString()
        is InputStream -> value.use { it.readBytes() }.decodeToString()
        else -> value
    }

    override fun nonNullValueToString(value: Any): String = when (value) {
        is ByteArray -> value.decodeToString()
        else -> value.toString()
    }
}