Top Description Methods
org.jooq

public Interface Collation

extends QueryPart
Known Direct Implementers
org.jooq.impl.CollationImpl
Imports
org.jooq.impl.DSL

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 TypeMethod and Description
public String
getName()

The name of the collation.

Inherited from org.jooq.QueryPart:
equalshashCodetoString

Method Detail

getNameback to summary
public String getName()

The name of the collation.