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

$replace, $replace, $traverse, $traverse, equals, hashCode, toString

Method Details

getName

String getName()

The name of the collation.