How can we define a case-insensitive unique varcha...

# exposed

[Fernando Sanchez (Perraco Labs)]

How can we define a case-insensitive unique varchar field in a table? Thanks

[Oleg Babichev]

As far as I know in Postgres there is a type citext for it. Which database you use?

[Oleg Babichev]

For me works the follogin variant:

class CitextColumnType : TextColumnType() {
    override fun sqlType() = "citext"
}

fun Table.citext(name: String): Column<String> =
    registerColumn(name, CitextColumnType())

@Test
    fun testTest() {
        val tester = object : IntIdTable("test-citext") {
            val text = citext("text").uniqueIndex()
        }

        withDb {
            addLogger(StdOutSqlLogger)
            exec("CREATE EXTENSION IF NOT EXISTS citext;")
            SchemaUtils.drop(tester)
            SchemaUtils.create(tester)

            tester.insert { it[text] = "abc" }
            assertFails {
                tester.insert { it[text] = "ABC" }
            }
        }
    }

[Fernando Sanchez (Perraco Labs)]

Using Postgres. Will check your code.