Package com.atlassian.jira.database

Class SupportedCollations

java.lang.Object

com.atlassian.jira.database.SupportedCollations

public class SupportedCollations
extends Object

JIRA officially supports a small number of database collations. They are:

• Oracle: BINARY
• Mysql: utf8mb4_bin, utf8mb4_0900_ai_ci (added in MySQL 8.0)
• Postgres: C, POSIX, POSIX.UTF-8, en_US.UTF-8 or English_United States:1252 (Windows Postgres)
• SQL Server: SQL_Latin1_General_CP437_CI_AI or Latin1_General_CI_AI
• HSQL: Any collation
• H2: Any collation

Constructor Summary

Constructors

Constructor	Description
SupportedCollations()

Method Summary

Modifier and Type	Method	Description
static Collection<String>	forDatabase(DatabaseConfig databaseConfig)
static boolean	isSupported(DatabaseConfig databaseConfig, String collation)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

SupportedCollations

public SupportedCollations()

Method Details

isSupported

public static boolean isSupported(DatabaseConfig databaseConfig,
 String collation)

Returns:

true if the collation is supported by JIRA

forDatabase

public static Collection<String> forDatabase(DatabaseConfig databaseConfig)

Returns:

the collection of collations supported for the given database config