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 Details

    • getName

      String getName()
      The name of the collation.