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 QueryPart

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

Method Details

getName

String getName()

The name of the collation.