Module org.jooq
Package org.jooq

Interface Collation

All Superinterfaces:
QueryPart, Serializable
public interface Collation extends QueryPart
A collation.

In SQL, a collation is a set of objects defining character encoding and/or sort order of character data. jOOQ supports the collation type in various SQL clauses of DDL and DML statements.

Example: 

 // Assuming import static org.jooq.impl.DSL.*;

 using(configuration)
    .select(ACTOR.FIRST_NAME, ACTOR.LAST_NAME)
    .from(ACTOR)
    .orderBy(
        ACTOR.FIRST_NAME.collate(collation("utf8_german2_ci")),
        ACTOR.LAST_NAME.collate(collation("utf8_german2_ci")))
    .fetch();

Instances can be created using DSL.collation(Name) and overloads.

Author:
Lukas Eder

  • Method Summary

    Modifier and Type
    Method
    Description
    String
    getName()
    The name of the collation.

    Methods inherited from interface org.jooq.QueryPart

    equals, hashCode, toString

  • Method Details

    • getName

      String getName()
      The name of the collation.