Package org.jooq

Interface Collation

All Superinterfaces:

QueryPart, java.io.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
java.lang.String	getName()	The name of the collation.

Methods inherited from interface org.jooq.QueryPart

equals, hashCode, toString

Method Detail

getName

java.lang.String getName()

The name of the collation.