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 Detail

      • getName

        java.lang.String getName()
        The name of the collation.