/* packet-mysql.c

* Routines for MySQL/MariaDB packet dissection

*

* Huagang XIE <[email protected]>

*

* MySQL 4.1+ protocol by Axel Schwenke <[email protected]>

* MariaDB protocol by Georg Richter <[email protected]>

* & Diego Dupin <[email protected]>

*

* Wireshark - Network traffic analyzer

* By Gerald Combs <[email protected]>

* Copyright 1998 Gerald Combs

*

* Copied from packet-tftp.c

*

* SPDX-License-Identifier: GPL-2.0-or-later

*

*

* the protocol specifications

* For MySQL at

* https://dev.mysql.com/doc/dev/mysql-server/latest/PAGE_PROTOCOL.html

* For MariaDB at

* https://mariadb.com/kb/en/clientserver-protocol/

* and MySQL source code

*/

/* create extra output for conversation tracking */

/* #define CTDEBUG 1 */

#include "config.h"

#include <epan/packet.h>

#include <epan/prefs.h>

#include <epan/expert.h>

#include <epan/tfs.h>

#include <wsutil/array.h>

#include <epan/proto_data.h>

#include <epan/reassemble.h>

#include <epan/exceptions.h>

#include <epan/show_exception.h>

#include "packet-tcp.h"

#include "packet-tls-utils.h"

void proto_register_mysql(void);

void proto_reg_handoff_mysql(void);

/* port for protocol registration */

#define TCP_PORT_MySQL 3306

#define MYSQL_HEADER_LENGTH 4

/* MariaDB Server >= 10.0 sends a 5.5.5- prefix for the version, since

replication doesn't support a two digit version number. Version 5.5.5

was never released in MySQL and MariaDB */

#define MARIADB_RPL_VERSION_HACK "5.5.5-"

/* client/server capabilities

* Docs: https://dev.mysql.com/doc/dev/mysql-server/latest/group__group__cs__capabilities__flags.html

* Source: https://github.com/mysql/mysql-server/blob/8.0/include/mysql_com.h

*/

#define MYSQL_CAPS_LP 0x0001 /* CLIENT_LONG_PASSWORD/CLIENT_IS_MYSQL */

#define MYSQL_CAPS_FR 0x0002 /* CLIENT_FOUND_ROWS */

#define MYSQL_CAPS_LF 0x0004 /* CLIENT_LONG_FLAG */

#define MYSQL_CAPS_CD 0x0008 /* CLIENT_CONNECT_WITH_DB */

#define MYSQL_CAPS_NS 0x0010 /* CLIENT_NO_SCHEMA */

#define MYSQL_CAPS_CP 0x0020 /* CLIENT_COMPRESS */

#define MYSQL_CAPS_OB 0x0040 /* CLIENT_ODBC */

#define MYSQL_CAPS_LI 0x0080 /* CLIENT_LOCAL_FILES */

#define MYSQL_CAPS_IS 0x0100 /* CLIENT_IGNORE_SPACE */

#define MYSQL_CAPS_CU 0x0200 /* CLIENT_PROTOCOL_41 */

#define MYSQL_CAPS_IA 0x0400 /* CLIENT_INTERACTIVE */

#define MYSQL_CAPS_SL 0x0800 /* CLIENT_SSL */

#define MYSQL_CAPS_II 0x1000 /* CLIENT_IGNORE_SPACE */

#define MYSQL_CAPS_TA 0x2000 /* CLIENT_TRANSACTIONS */

#define MYSQL_CAPS_RS 0x4000 /* CLIENT_RESERVED */

#define MYSQL_CAPS_SC 0x8000 /* CLIENT_SECURE_CONNECTION */

/* field flags */

#define MYSQL_FLD_NOT_NULL_FLAG 0x0001

#define MYSQL_FLD_PRI_KEY_FLAG 0x0002

#define MYSQL_FLD_UNIQUE_KEY_FLAG 0x0004

#define MYSQL_FLD_MULTIPLE_KEY_FLAG 0x0008

#define MYSQL_FLD_BLOB_FLAG 0x0010

#define MYSQL_FLD_UNSIGNED_FLAG 0x0020

#define MYSQL_FLD_ZEROFILL_FLAG 0x0040

#define MYSQL_FLD_BINARY_FLAG 0x0080

#define MYSQL_FLD_ENUM_FLAG 0x0100

#define MYSQL_FLD_AUTO_INCREMENT_FLAG 0x0200

#define MYSQL_FLD_TIMESTAMP_FLAG 0x0400

#define MYSQL_FLD_SET_FLAG 0x0800

/* param flags */

#define PARAM_UNSIGNED 0x80

/* extended capabilities: 4.1+ client only

*

* These are libmysqlclient flags and NOT present

* in the protocol:

* CLIENT_REMEMBER_OPTIONS (1UL << 31)

*/

#define MYSQL_CAPS_MS 0x0001 /* CLIENT_MULTI_STATEMENTS */

#define MYSQL_CAPS_MR 0x0002 /* CLIENT_MULTI_RESULTS */

#define MYSQL_CAPS_PM 0x0004 /* CLIENT_PS_MULTI_RESULTS */

#define MYSQL_CAPS_PA 0x0008 /* CLIENT_PLUGIN_AUTH */

#define MYSQL_CAPS_CA 0x0010 /* CLIENT_CONNECT_ATTRS */

#define MYSQL_CAPS_AL 0x0020 /* CLIENT_PLUGIN_AUTH_LENENC_CLIENT_DATA */

#define MYSQL_CAPS_EP 0x0040 /* CLIENT_CAN_HANDLE_EXPIRED_PASSWORDS */

#define MYSQL_CAPS_ST 0x0080 /* CLIENT_SESSION_TRACK */

#define MYSQL_CAPS_DE 0x0100 /* CLIENT_DEPRECATE_EOF */

#define MYSQL_CAPS_RM 0x0200 /* CLIENT_OPTIONAL_RESULTSET_METADATA */

#define MYSQL_CAPS_ZS 0x0400 /* CLIENT_ZSTD_COMPRESSION_ALGORITHM */

#define MYSQL_CAPS_QA 0x0800 /* CLIENT_QUERY_ATTRIBUTES */

#define MYSQL_CAPS_MF 0x1000 /* MULTI_FACTOR_AUTHENTICATION */

#define MYSQL_CAPS_CE 0x2000 /* CLIENT_CAPABILITY_EXTENSION */

#define MYSQL_CAPS_VC 0x4000 /* CLIENT_SSL_VERIFY_SERVER_CERT */

#define MYSQL_CAPS_UNUSED 0x8000 /* Currently only a single bit */

/* status bitfield */

#define MYSQL_STAT_IT 0x0001

#define MYSQL_STAT_AC 0x0002

#define MYSQL_STAT_MU 0x0004

#define MYSQL_STAT_MR 0x0008

#define MYSQL_STAT_BI 0x0010

#define MYSQL_STAT_NI 0x0020

#define MYSQL_STAT_CR 0x0040

#define MYSQL_STAT_LR 0x0080

#define MYSQL_STAT_DR 0x0100

#define MYSQL_STAT_BS 0x0200

#define MYSQL_STAT_MC 0x0400

#define MYSQL_STAT_QUERY_WAS_SLOW 0x0800

#define MYSQL_STAT_PS_OUT_PARAMS 0x1000

#define MYSQL_STAT_TRANS_READONLY 0x2000

#define MYSQL_STAT_SESSION_STATE_CHANGED 0x4000

/* bitfield for MYSQL_REFRESH */

#define MYSQL_RFSH_GRANT 1 /* Refresh grant tables */

#define MYSQL_RFSH_LOG 2 /* Start on new log file */

#define MYSQL_RFSH_TABLES 4 /* close all tables */

#define MYSQL_RFSH_HOSTS 8 /* Flush host cache */

#define MYSQL_RFSH_STATUS 16 /* Flush status variables */

#define MYSQL_RFSH_THREADS 32 /* Flush thread cache */

#define MYSQL_RFSH_SLAVE 64 /* Reset master info and restart slave thread */

#define MYSQL_RFSH_MASTER 128 /* Remove all bin logs in the index and truncate the index */

/* MySQL command codes (enum_server_command in mysql-server.git:include/my_command.h) */

#define MYSQL_SLEEP 0 /* not from client */

#define MYSQL_QUIT 1

#define MYSQL_INIT_DB 2

#define MYSQL_QUERY 3

#define MYSQL_FIELD_LIST 4

#define MYSQL_CREATE_DB 5

#define MYSQL_DROP_DB 6

#define MYSQL_REFRESH 7

#define MYSQL_SHUTDOWN 8

#define MYSQL_STATISTICS 9

#define MYSQL_PROCESS_INFO 10

#define MYSQL_CONNECT 11 /* not from client */

#define MYSQL_PROCESS_KILL 12

#define MYSQL_DEBUG 13

#define MYSQL_PING 14

#define MYSQL_TIME 15 /* not from client */

#define MYSQL_DELAY_INSERT 16 /* not from client */

#define MYSQL_CHANGE_USER 17

#define MYSQL_BINLOG_DUMP 18 /* replication */

#define MYSQL_TABLE_DUMP 19 /* replication */

#define MYSQL_CONNECT_OUT 20 /* replication */

#define MYSQL_REGISTER_SLAVE 21 /* replication */

#define MYSQL_STMT_PREPARE 22

#define MYSQL_STMT_EXECUTE 23

#define MYSQL_STMT_SEND_LONG_DATA 24

#define MYSQL_STMT_CLOSE 25

#define MYSQL_STMT_RESET 26

#define MYSQL_SET_OPTION 27

#define MYSQL_STMT_FETCH 28

#define MYSQL_DAEMON 29

#define MYSQL_BINLOG_DUMP_GTID 30 /* replication */

#define MYSQL_RESET_CONNECTION 31

#define MYSQL_CLONE 32

#define MYSQL_SUBSCRIBE_GROUP_REPLICATION_STREAM 33

/* MySQL Native Cloning Commands */

#define MYSQL_CLONE_COM_INIT 1

#define MYSQL_CLONE_COM_ATTACH 2

#define MYSQL_CLONE_COM_REINIT 3

#define MYSQL_CLONE_COM_EXECUTE 4

#define MYSQL_CLONE_COM_ACK 5

#define MYSQL_CLONE_COM_EXIT 6

/* decoding table: clone command */

static const value_string mysql_clone_command_vals[] = {

{MYSQL_CLONE_COM_INIT, "Init"},

{MYSQL_CLONE_COM_ATTACH, "Attach"},

{MYSQL_CLONE_COM_REINIT, "Re-init"},

{MYSQL_CLONE_COM_EXECUTE, "Execute"},

{MYSQL_CLONE_COM_ACK, "Ack"},

{MYSQL_CLONE_COM_EXIT, "Exit"},

{0, NULL}

};

/* MySQL Native Cloning Responses */

#define MYSQL_CLONE_COM_RES_LOCS 1

#define MYSQL_CLONE_COM_RES_DATA_DESC 2

#define MYSQL_CLONE_COM_RES_DATA 3

#define MYSQL_CLONE_COM_RES_PLUGIN 4

#define MYSQL_CLONE_COM_RES_CONFIG 5

#define MYSQL_CLONE_COM_RES_COLLATION 6

#define MYSQL_CLONE_COM_RES_PLUGIN_V2 7

#define MYSQL_CLONE_COM_RES_CONFIG_V3 8

#define MYSQL_CLONE_COM_RES_COMPLETE 99

#define MYSQL_CLONE_COM_RES_ERROR 100

/* decoding table: clone command */

static const value_string mysql_clone_response_vals[] = {

{MYSQL_CLONE_COM_RES_LOCS, "Remote Resource Locator"},

{MYSQL_CLONE_COM_RES_DATA_DESC, "Remote Data Descriptor"},

{MYSQL_CLONE_COM_RES_DATA, "Remote Data"},

{MYSQL_CLONE_COM_RES_PLUGIN, "Plugin V1"},

{MYSQL_CLONE_COM_RES_CONFIG, "Config"},

{MYSQL_CLONE_COM_RES_COLLATION, "Collation"},

{MYSQL_CLONE_COM_RES_PLUGIN_V2, "Plugin V2"},

{MYSQL_CLONE_COM_RES_CONFIG_V3, "Plugin V3"},

{MYSQL_CLONE_COM_RES_COMPLETE, "Complete"},

{MYSQL_CLONE_COM_RES_ERROR, "Error"},

{0, NULL}

};

/* MariaDB specific commands */

#define MARIADB_STMT_BULK_EXECUTE 250

/* MariaDB bulk execute flags */

#define MARIADB_BULK_AUTOID 64

#define MARIADB_BULK_SEND_TYPES 128

/* MariaDB extended capabilities */

#define MARIADB_CAPS_PR 0x00000001 /* MARIADB_CLIENT_PROGRESS */

#define MARIADB_CAPS_CM 0x00000002 /* MARIADB_CLIENT_COM_MULTI */

#define MARIADB_CAPS_BO 0x00000004 /* MARIADB_CLIENT_STMT_BULK_OPERATIONS */

#define MARIADB_CAPS_EM 0x00000008 /* MARIADB_CLIENT_EXTENDED_METADATA */

#define MARIADB_CAPS_ME 0x00000010 /* MARIADB_CLIENT_CACHE_METADATA */

/* MariaDB bulk indicators */

#define MARIADB_INDICATOR_NONE 0

#define MARIADB_INDICATOR_NULL 1

#define MARIADB_INDICATOR_DEFAULT 2

#define MARIADB_INDICATOR_IGNORE 3

#define MARIADB_INDICATIR_IGNORE_ROW 4

/* MySQL cursor types */

#define MYSQL_CURSOR_TYPE_NO_CURSOR 0

#define MYSQL_CURSOR_TYPE_READ_ONLY 1

#define MYSQL_CURSOR_TYPE_FOR_UPDATE 2

#define MYSQL_CURSOR_TYPE_SCROLLABLE 4

#define MYSQL_PARAMETER_COUNT_AVAILABLE 8

/* MySQL parameter flags -- used internally by the dissector */

#define MYSQL_PARAM_FLAG_STREAMED 0x01

/* Compression states, internal to the dissector */

#define MYSQL_COMPRESS_NONE 0

#define MYSQL_COMPRESS_INIT 1

#define MYSQL_COMPRESS_ACTIVE 2

#define MYSQL_COMPRESS_ALG_ZLIB 0

#define MYSQL_COMPRESS_ALG_ZSTD 1

/* Generic Response Codes */

#define MYSQL_RESPONSE_OK 0x00

#define MYSQL_RESPONSE_ERR 0xFF

#define MYSQL_RESPONSE_EOF 0xFE

#define MYSQL_RESPONSE_INFILE 0xFB

/* mariadb extended keys */

#define MARIADB_EXT_META_TYPE 0

#define MARIADB_EXT_META_FORMAT 1

/* decoding table: command */

static const value_string mysql_command_vals[] = {

{MYSQL_SLEEP, "SLEEP"},

{MYSQL_QUIT, "Quit"},

{MYSQL_INIT_DB, "Use Database"},

{MYSQL_QUERY, "Query"},

{MYSQL_FIELD_LIST, "Show Fields"},

{MYSQL_CREATE_DB, "Create Database"},

{MYSQL_DROP_DB , "Drop Database"},

{MYSQL_REFRESH , "Refresh"},

{MYSQL_SHUTDOWN , "Shutdown"},

{MYSQL_STATISTICS , "Statistics"},

{MYSQL_PROCESS_INFO , "Process List"},

{MYSQL_CONNECT , "Connect"},

{MYSQL_PROCESS_KILL , "Kill Server Thread"},

{MYSQL_DEBUG , "Dump Debuginfo"},

{MYSQL_PING , "Ping"},

{MYSQL_TIME , "Time"},

{MYSQL_DELAY_INSERT , "Insert Delayed"},

{MYSQL_CHANGE_USER , "Change User"},

{MYSQL_BINLOG_DUMP , "Send Binlog"},

{MYSQL_TABLE_DUMP, "Send Table"},

{MYSQL_CONNECT_OUT, "Slave Connect"},

{MYSQL_REGISTER_SLAVE, "Register Slave"},

{MYSQL_STMT_PREPARE, "Prepare Statement"},

{MYSQL_STMT_EXECUTE, "Execute Statement"},

{MYSQL_STMT_SEND_LONG_DATA, "Send BLOB"},

{MYSQL_STMT_CLOSE, "Close Statement"},

{MYSQL_STMT_RESET, "Reset Statement"},

{MYSQL_SET_OPTION, "Set Option"},

{MYSQL_STMT_FETCH, "Fetch Data"},

{MYSQL_DAEMON, "Daemon"},

{MYSQL_BINLOG_DUMP_GTID, "Send Binlog GTID"},

{MYSQL_RESET_CONNECTION, "Reset Connection"},

{MYSQL_CLONE, "Native cloning"},

{MYSQL_SUBSCRIBE_GROUP_REPLICATION_STREAM, "Subscribe Group Replication Stream"},

{MARIADB_STMT_BULK_EXECUTE, "Execute Bulk Statement"},

{0, NULL}

};

static value_string_ext mysql_command_vals_ext = VALUE_STRING_EXT_INIT(mysql_command_vals);

/* decoding table: exec_flags */

static const value_string mysql_exec_flags_vals[] = {

{MYSQL_CURSOR_TYPE_NO_CURSOR, "Defaults"},

{MYSQL_CURSOR_TYPE_READ_ONLY, "Read-only cursor"},

{MYSQL_CURSOR_TYPE_FOR_UPDATE, "Cursor for update"},

{MYSQL_CURSOR_TYPE_SCROLLABLE, "Scrollable cursor"},

{MYSQL_PARAMETER_COUNT_AVAILABLE, "Parameter Count Available"},

{0, NULL}

};

/* decoding table: new_parameter_bound_flag */

static const value_string mysql_new_parameter_bound_flag_vals[] = {

{0, "Subsequent call"},

{1, "First call or rebound"},

{0, NULL}

};

/*

static const value_string mariadb_bulk_flags_vals[] = {

{MARIADB_BULK_AUTOID, "Return auto generated IDs"},

{MARIADB_BULK_SEND_TYPES, "Send types to server"},

{0, NULL}

};

*/

static const value_string mariadb_bulk_indicator_vals[] = {

{MARIADB_INDICATOR_NONE, "Not set"},

{MARIADB_INDICATOR_NULL, "Null Value"},

{MARIADB_INDICATOR_DEFAULT, "Default Value"},

{MARIADB_INDICATOR_IGNORE, "Don't Update Value"},

{MARIADB_INDICATIR_IGNORE_ROW, "Ignore Row"},

{0, NULL}

};

/* decoding table: exec_time_sign */

static const value_string mysql_exec_time_sign_vals[] = {

{0, "Positive"},

{1, "Negative"},

{0, NULL}

};

/* collation codes may change over time, recreate with the following SQL

SELECT CONCAT(' {', ID, ',"', CHARACTER_SET_NAME, ' COLLATE ', COLLATION_NAME, '"},')

FROM INFORMATION_SCHEMA.COLLATIONS

ORDER BY ID

INTO OUTFILE '/var/lib/mysql-files/mysql-collations';

Last Update from MySQL 8.0.36

*/

static const value_string mysql_collation_vals[] = {

{1, "big5 COLLATE big5_chinese_ci"},

{2, "latin2 COLLATE latin2_czech_cs"},

{3, "dec8 COLLATE dec8_swedish_ci"},

{4, "cp850 COLLATE cp850_general_ci"},

{5, "latin1 COLLATE latin1_german1_ci"},

{6, "hp8 COLLATE hp8_english_ci"},

{7, "koi8r COLLATE koi8r_general_ci"},

{8, "latin1 COLLATE latin1_swedish_ci"},

{9, "latin2 COLLATE latin2_general_ci"},

{10, "swe7 COLLATE swe7_swedish_ci"},

{11, "ascii COLLATE ascii_general_ci"},

{12, "ujis COLLATE ujis_japanese_ci"},

{13, "sjis COLLATE sjis_japanese_ci"},

{14, "cp1251 COLLATE cp1251_bulgarian_ci"},

{15, "latin1 COLLATE latin1_danish_ci"},

{16, "hebrew COLLATE hebrew_general_ci"},

{18, "tis620 COLLATE tis620_thai_ci"},

{19, "euckr COLLATE euckr_korean_ci"},

{20, "latin7 COLLATE latin7_estonian_cs"},

{21, "latin2 COLLATE latin2_hungarian_ci"},

{22, "koi8u COLLATE koi8u_general_ci"},

{23, "cp1251 COLLATE cp1251_ukrainian_ci"},

{24, "gb2312 COLLATE gb2312_chinese_ci"},

{25, "greek COLLATE greek_general_ci"},

{26, "cp1250 COLLATE cp1250_general_ci"},

{27, "latin2 COLLATE latin2_croatian_ci"},

{28, "gbk COLLATE gbk_chinese_ci"},

{29, "cp1257 COLLATE cp1257_lithuanian_ci"},

{30, "latin5 COLLATE latin5_turkish_ci"},

{31, "latin1 COLLATE latin1_german2_ci"},

{32, "armscii8 COLLATE armscii8_general_ci"},

{33, "utf8mb3 COLLATE utf8mb3_general_ci"},

{34, "cp1250 COLLATE cp1250_czech_cs"},

{35, "ucs2 COLLATE ucs2_general_ci"},

{36, "cp866 COLLATE cp866_general_ci"},

{37, "keybcs2 COLLATE keybcs2_general_ci"},

{38, "macce COLLATE macce_general_ci"},

{39, "macroman COLLATE macroman_general_ci"},

{40, "cp852 COLLATE cp852_general_ci"},

{41, "latin7 COLLATE latin7_general_ci"},

{42, "latin7 COLLATE latin7_general_cs"},

{43, "macce COLLATE macce_bin"},

{44, "cp1250 COLLATE cp1250_croatian_ci"},

{45, "utf8mb4 COLLATE utf8mb4_general_ci"},

{46, "utf8mb4 COLLATE utf8mb4_bin"},

{47, "latin1 COLLATE latin1_bin"},

{48, "latin1 COLLATE latin1_general_ci"},

{49, "latin1 COLLATE latin1_general_cs"},

{50, "cp1251 COLLATE cp1251_bin"},

{51, "cp1251 COLLATE cp1251_general_ci"},

{52, "cp1251 COLLATE cp1251_general_cs"},

{53, "macroman COLLATE macroman_bin"},

{54, "utf16 COLLATE utf16_general_ci"},

{55, "utf16 COLLATE utf16_bin"},

{56, "utf16le COLLATE utf16le_general_ci"},

{57, "cp1256 COLLATE cp1256_general_ci"},

{58, "cp1257 COLLATE cp1257_bin"},

{59, "cp1257 COLLATE cp1257_general_ci"},

{60, "utf32 COLLATE utf32_general_ci"},

{61, "utf32 COLLATE utf32_bin"},

{62, "utf16le COLLATE utf16le_bin"},

{63, "binary COLLATE binary"},

{64, "armscii8 COLLATE armscii8_bin"},

{65, "ascii COLLATE ascii_bin"},

{66, "cp1250 COLLATE cp1250_bin"},

{67, "cp1256 COLLATE cp1256_bin"},

{68, "cp866 COLLATE cp866_bin"},

{69, "dec8 COLLATE dec8_bin"},

{70, "greek COLLATE greek_bin"},

{71, "hebrew COLLATE hebrew_bin"},

{72, "hp8 COLLATE hp8_bin"},

{73, "keybcs2 COLLATE keybcs2_bin"},

{74, "koi8r COLLATE koi8r_bin"},

{75, "koi8u COLLATE koi8u_bin"},

{76, "utf8mb3 COLLATE utf8mb3_tolower_ci"},

{77, "latin2 COLLATE latin2_bin"},

{78, "latin5 COLLATE latin5_bin"},

{79, "latin7 COLLATE latin7_bin"},

{80, "cp850 COLLATE cp850_bin"},

{81, "cp852 COLLATE cp852_bin"},

{82, "swe7 COLLATE swe7_bin"},

{83, "utf8mb3 COLLATE utf8mb3_bin"},

{84, "big5 COLLATE big5_bin"},

{85, "euckr COLLATE euckr_bin"},

{86, "gb2312 COLLATE gb2312_bin"},

{87, "gbk COLLATE gbk_bin"},

{88, "sjis COLLATE sjis_bin"},

{89, "tis620 COLLATE tis620_bin"},

{90, "ucs2 COLLATE ucs2_bin"},

{91, "ujis COLLATE ujis_bin"},

{92, "geostd8 COLLATE geostd8_general_ci"},

{93, "geostd8 COLLATE geostd8_bin"},

{94, "latin1 COLLATE latin1_spanish_ci"},

{95, "cp932 COLLATE cp932_japanese_ci"},

{96, "cp932 COLLATE cp932_bin"},

{97, "eucjpms COLLATE eucjpms_japanese_ci"},

{98, "eucjpms COLLATE eucjpms_bin"},

{99, "cp1250 COLLATE cp1250_polish_ci"},

{101, "utf16 COLLATE utf16_unicode_ci"},

{102, "utf16 COLLATE utf16_icelandic_ci"},

{103, "utf16 COLLATE utf16_latvian_ci"},

{104, "utf16 COLLATE utf16_romanian_ci"},

{105, "utf16 COLLATE utf16_slovenian_ci"},

{106, "utf16 COLLATE utf16_polish_ci"},

{107, "utf16 COLLATE utf16_estonian_ci"},

{108, "utf16 COLLATE utf16_spanish_ci"},

{109, "utf16 COLLATE utf16_swedish_ci"},

{110, "utf16 COLLATE utf16_turkish_ci"},

{111, "utf16 COLLATE utf16_czech_ci"},

{112, "utf16 COLLATE utf16_danish_ci"},

{113, "utf16 COLLATE utf16_lithuanian_ci"},

{114, "utf16 COLLATE utf16_slovak_ci"},

{115, "utf16 COLLATE utf16_spanish2_ci"},

{116, "utf16 COLLATE utf16_roman_ci"},

{117, "utf16 COLLATE utf16_persian_ci"},

{118, "utf16 COLLATE utf16_esperanto_ci"},

{119, "utf16 COLLATE utf16_hungarian_ci"},

{120, "utf16 COLLATE utf16_sinhala_ci"},

{121, "utf16 COLLATE utf16_german2_ci"},

{122, "utf16 COLLATE utf16_croatian_ci"},

{123, "utf16 COLLATE utf16_unicode_520_ci"},

{124, "utf16 COLLATE utf16_vietnamese_ci"},

{128, "ucs2 COLLATE ucs2_unicode_ci"},

{129, "ucs2 COLLATE ucs2_icelandic_ci"},

{130, "ucs2 COLLATE ucs2_latvian_ci"},

{131, "ucs2 COLLATE ucs2_romanian_ci"},

{132, "ucs2 COLLATE ucs2_slovenian_ci"},

{133, "ucs2 COLLATE ucs2_polish_ci"},

{134, "ucs2 COLLATE ucs2_estonian_ci"},

{135, "ucs2 COLLATE ucs2_spanish_ci"},

{136, "ucs2 COLLATE ucs2_swedish_ci"},

{137, "ucs2 COLLATE ucs2_turkish_ci"},

{138, "ucs2 COLLATE ucs2_czech_ci"},

{139, "ucs2 COLLATE ucs2_danish_ci"},

{140, "ucs2 COLLATE ucs2_lithuanian_ci"},

{141, "ucs2 COLLATE ucs2_slovak_ci"},

{142, "ucs2 COLLATE ucs2_spanish2_ci"},

{143, "ucs2 COLLATE ucs2_roman_ci"},

{144, "ucs2 COLLATE ucs2_persian_ci"},

{145, "ucs2 COLLATE ucs2_esperanto_ci"},

{146, "ucs2 COLLATE ucs2_hungarian_ci"},

{147, "ucs2 COLLATE ucs2_sinhala_ci"},

{148, "ucs2 COLLATE ucs2_german2_ci"},

{149, "ucs2 COLLATE ucs2_croatian_ci"},

{150, "ucs2 COLLATE ucs2_unicode_520_ci"},

{151, "ucs2 COLLATE ucs2_vietnamese_ci"},

{159, "ucs2 COLLATE ucs2_general_mysql500_ci"},

{160, "utf32 COLLATE utf32_unicode_ci"},

{161, "utf32 COLLATE utf32_icelandic_ci"},

{162, "utf32 COLLATE utf32_latvian_ci"},

{163, "utf32 COLLATE utf32_romanian_ci"},

{164, "utf32 COLLATE utf32_slovenian_ci"},

{165, "utf32 COLLATE utf32_polish_ci"},

{166, "utf32 COLLATE utf32_estonian_ci"},

{167, "utf32 COLLATE utf32_spanish_ci"},

{168, "utf32 COLLATE utf32_swedish_ci"},

{169, "utf32 COLLATE utf32_turkish_ci"},

{170, "utf32 COLLATE utf32_czech_ci"},

{171, "utf32 COLLATE utf32_danish_ci"},

{172, "utf32 COLLATE utf32_lithuanian_ci"},

{173, "utf32 COLLATE utf32_slovak_ci"},

{174, "utf32 COLLATE utf32_spanish2_ci"},

{175, "utf32 COLLATE utf32_roman_ci"},

{176, "utf32 COLLATE utf32_persian_ci"},

{177, "utf32 COLLATE utf32_esperanto_ci"},

{178, "utf32 COLLATE utf32_hungarian_ci"},

{179, "utf32 COLLATE utf32_sinhala_ci"},

{180, "utf32 COLLATE utf32_german2_ci"},

{181, "utf32 COLLATE utf32_croatian_ci"},

{182, "utf32 COLLATE utf32_unicode_520_ci"},

{183, "utf32 COLLATE utf32_vietnamese_ci"},

{192, "utf8mb3 COLLATE utf8mb3_unicode_ci"},

{193, "utf8mb3 COLLATE utf8mb3_icelandic_ci"},

{194, "utf8mb3 COLLATE utf8mb3_latvian_ci"},

{195, "utf8mb3 COLLATE utf8mb3_romanian_ci"},

{196, "utf8mb3 COLLATE utf8mb3_slovenian_ci"},

{197, "utf8mb3 COLLATE utf8mb3_polish_ci"},

{198, "utf8mb3 COLLATE utf8mb3_estonian_ci"},

{199, "utf8mb3 COLLATE utf8mb3_spanish_ci"},

{200, "utf8mb3 COLLATE utf8mb3_swedish_ci"},

{201, "utf8mb3 COLLATE utf8mb3_turkish_ci"},

{202, "utf8mb3 COLLATE utf8mb3_czech_ci"},

{203, "utf8mb3 COLLATE utf8mb3_danish_ci"},

{204, "utf8mb3 COLLATE utf8mb3_lithuanian_ci"},

{205, "utf8mb3 COLLATE utf8mb3_slovak_ci"},

{206, "utf8mb3 COLLATE utf8mb3_spanish2_ci"},

{207, "utf8mb3 COLLATE utf8mb3_roman_ci"},

{208, "utf8mb3 COLLATE utf8mb3_persian_ci"},

{209, "utf8mb3 COLLATE utf8mb3_esperanto_ci"},

{210, "utf8mb3 COLLATE utf8mb3_hungarian_ci"},

{211, "utf8mb3 COLLATE utf8mb3_sinhala_ci"},

{212, "utf8mb3 COLLATE utf8mb3_german2_ci"},

{213, "utf8mb3 COLLATE utf8mb3_croatian_ci"},

{214, "utf8mb3 COLLATE utf8mb3_unicode_520_ci"},

{215, "utf8mb3 COLLATE utf8mb3_vietnamese_ci"},

{223, "utf8mb3 COLLATE utf8mb3_general_mysql500_ci"},

{224, "utf8mb4 COLLATE utf8mb4_unicode_ci"},

{225, "utf8mb4 COLLATE utf8mb4_icelandic_ci"},

{226, "utf8mb4 COLLATE utf8mb4_latvian_ci"},

{227, "utf8mb4 COLLATE utf8mb4_romanian_ci"},

{228, "utf8mb4 COLLATE utf8mb4_slovenian_ci"},

{229, "utf8mb4 COLLATE utf8mb4_polish_ci"},

{230, "utf8mb4 COLLATE utf8mb4_estonian_ci"},

{231, "utf8mb4 COLLATE utf8mb4_spanish_ci"},

{232, "utf8mb4 COLLATE utf8mb4_swedish_ci"},

{233, "utf8mb4 COLLATE utf8mb4_turkish_ci"},

{234, "utf8mb4 COLLATE utf8mb4_czech_ci"},

{235, "utf8mb4 COLLATE utf8mb4_danish_ci"},

{236, "utf8mb4 COLLATE utf8mb4_lithuanian_ci"},

{237, "utf8mb4 COLLATE utf8mb4_slovak_ci"},

{238, "utf8mb4 COLLATE utf8mb4_spanish2_ci"},

{239, "utf8mb4 COLLATE utf8mb4_roman_ci"},

{240, "utf8mb4 COLLATE utf8mb4_persian_ci"},

{241, "utf8mb4 COLLATE utf8mb4_esperanto_ci"},

{242, "utf8mb4 COLLATE utf8mb4_hungarian_ci"},

{243, "utf8mb4 COLLATE utf8mb4_sinhala_ci"},

{244, "utf8mb4 COLLATE utf8mb4_german2_ci"},

{245, "utf8mb4 COLLATE utf8mb4_croatian_ci"},

{246, "utf8mb4 COLLATE utf8mb4_unicode_520_ci"},

{247, "utf8mb4 COLLATE utf8mb4_vietnamese_ci"},

{248,"gb18030 COLLATE gb18030_chinese_ci"},

{249,"gb18030 COLLATE gb18030_bin"},

{250,"gb18030 COLLATE gb18030_unicode_520_ci"},

{255,"utf8mb4 COLLATE utf8mb4_0900_ai_ci"},

{256,"utf8mb4 COLLATE utf8mb4_de_pb_0900_ai_ci"},

{257,"utf8mb4 COLLATE utf8mb4_is_0900_ai_ci"},

{258,"utf8mb4 COLLATE utf8mb4_lv_0900_ai_ci"},

{259,"utf8mb4 COLLATE utf8mb4_ro_0900_ai_ci"},

{260,"utf8mb4 COLLATE utf8mb4_sl_0900_ai_ci"},

{261,"utf8mb4 COLLATE utf8mb4_pl_0900_ai_ci"},

{262,"utf8mb4 COLLATE utf8mb4_et_0900_ai_ci"},

{263,"utf8mb4 COLLATE utf8mb4_es_0900_ai_ci"},

{264,"utf8mb4 COLLATE utf8mb4_sv_0900_ai_ci"},

{265,"utf8mb4 COLLATE utf8mb4_tr_0900_ai_ci"},

{266,"utf8mb4 COLLATE utf8mb4_cs_0900_ai_ci"},

{267,"utf8mb4 COLLATE utf8mb4_da_0900_ai_ci"},

{268,"utf8mb4 COLLATE utf8mb4_lt_0900_ai_ci"},

{269,"utf8mb4 COLLATE utf8mb4_sk_0900_ai_ci"},

{270,"utf8mb4 COLLATE utf8mb4_es_trad_0900_ai_ci"},

{271,"utf8mb4 COLLATE utf8mb4_la_0900_ai_ci"},

{273,"utf8mb4 COLLATE utf8mb4_eo_0900_ai_ci"},

{274,"utf8mb4 COLLATE utf8mb4_hu_0900_ai_ci"},

{275,"utf8mb4 COLLATE utf8mb4_hr_0900_ai_ci"},

{277,"utf8mb4 COLLATE utf8mb4_vi_0900_ai_ci"},

{278,"utf8mb4 COLLATE utf8mb4_0900_as_cs"},

{279,"utf8mb4 COLLATE utf8mb4_de_pb_0900_as_cs"},

{280,"utf8mb4 COLLATE utf8mb4_is_0900_as_cs"},

{281,"utf8mb4 COLLATE utf8mb4_lv_0900_as_cs"},

{282,"utf8mb4 COLLATE utf8mb4_ro_0900_as_cs"},

{283,"utf8mb4 COLLATE utf8mb4_sl_0900_as_cs"},

{284,"utf8mb4 COLLATE utf8mb4_pl_0900_as_cs"},

{285,"utf8mb4 COLLATE utf8mb4_et_0900_as_cs"},

{286,"utf8mb4 COLLATE utf8mb4_es_0900_as_cs"},

{287,"utf8mb4 COLLATE utf8mb4_sv_0900_as_cs"},

{288,"utf8mb4 COLLATE utf8mb4_tr_0900_as_cs"},

{289,"utf8mb4 COLLATE utf8mb4_cs_0900_as_cs"},

{290,"utf8mb4 COLLATE utf8mb4_da_0900_as_cs"},

{291,"utf8mb4 COLLATE utf8mb4_lt_0900_as_cs"},

{292,"utf8mb4 COLLATE utf8mb4_sk_0900_as_cs"},

{293,"utf8mb4 COLLATE utf8mb4_es_trad_0900_as_cs"},

{294,"utf8mb4 COLLATE utf8mb4_la_0900_as_cs"},

{296,"utf8mb4 COLLATE utf8mb4_eo_0900_as_cs"},

{297,"utf8mb4 COLLATE utf8mb4_hu_0900_as_cs"},

{298,"utf8mb4 COLLATE utf8mb4_hr_0900_as_cs"},

{300,"utf8mb4 COLLATE utf8mb4_vi_0900_as_cs"},

{303,"utf8mb4 COLLATE utf8mb4_ja_0900_as_cs"},

{304,"utf8mb4 COLLATE utf8mb4_ja_0900_as_cs_ks"},

{305,"utf8mb4 COLLATE utf8mb4_0900_as_ci"},

{306,"utf8mb4 COLLATE utf8mb4_ru_0900_ai_ci"},

{307,"utf8mb4 COLLATE utf8mb4_ru_0900_as_cs"},

{308,"utf8mb4 COLLATE utf8mb4_zh_0900_as_cs"},

{309,"utf8mb4 COLLATE utf8mb4_0900_bin"},

{310,"utf8mb4 COLLATE utf8mb4_nb_0900_ai_ci"},

{311,"utf8mb4 COLLATE utf8mb4_nb_0900_as_cs"},

{312,"utf8mb4 COLLATE utf8mb4_nn_0900_ai_ci"},

{313,"utf8mb4 COLLATE utf8mb4_nn_0900_as_cs"},

{314,"utf8mb4 COLLATE utf8mb4_sr_latn_0900_ai_ci"},

{315,"utf8mb4 COLLATE utf8mb4_sr_latn_0900_as_cs"},

{316,"utf8mb4 COLLATE utf8mb4_bs_0900_ai_ci"},

{317,"utf8mb4 COLLATE utf8mb4_bs_0900_as_cs"},

{318,"utf8mb4 COLLATE utf8mb4_bg_0900_ai_ci"},

{319,"utf8mb4 COLLATE utf8mb4_bg_0900_as_cs"},

{320,"utf8mb4 COLLATE utf8mb4_gl_0900_ai_ci"},

{321,"utf8mb4 COLLATE utf8mb4_gl_0900_as_cs"},

{322,"utf8mb4 COLLATE utf8mb4_mn_cyrl_0900_ai_ci"},

{323,"utf8mb4 COLLATE utf8mb4_mn_cyrl_0900_as_cs"},

{0, NULL}

};

static value_string_ext mysql_collation_vals_ext = VALUE_STRING_EXT_INIT(mysql_collation_vals);

/* MariaDB specific character sets and collations

Last Update: MariaDB 10.5.4 */

static const value_string mariadb_collation_vals[] = {

{1,"big5 COLLATE big5_chinese_ci"},

{2,"latin2 COLLATE latin2_czech_cs"},

{3,"dec8 COLLATE dec8_swedish_ci"},

{4,"cp850 COLLATE cp850_general_ci"},

{5,"latin1 COLLATE latin1_german1_ci"},

{6,"hp8 COLLATE hp8_english_ci"},

{7,"koi8r COLLATE koi8r_general_ci"},

{8,"latin1 COLLATE latin1_swedish_ci"},

{9,"latin2 COLLATE latin2_general_ci"},

{10,"swe7 COLLATE swe7_swedish_ci"},

{11,"ascii COLLATE ascii_general_ci"},

{12,"ujis COLLATE ujis_japanese_ci"},

{13,"sjis COLLATE sjis_japanese_ci"},

{14,"cp1251 COLLATE cp1251_bulgarian_ci"},

{15,"latin1 COLLATE latin1_danish_ci"},

{16,"hebrew COLLATE hebrew_general_ci"},

{18,"tis620 COLLATE tis620_thai_ci"},

{19,"euckr COLLATE euckr_korean_ci"},

{20,"latin7 COLLATE latin7_estonian_cs"},

{21,"latin2 COLLATE latin2_hungarian_ci"},

{22,"koi8u COLLATE koi8u_general_ci"},

{23,"cp1251 COLLATE cp1251_ukrainian_ci"},

{24,"gb2312 COLLATE gb2312_chinese_ci"},

{25,"greek COLLATE greek_general_ci"},

{26,"cp1250 COLLATE cp1250_general_ci"},

{27,"latin2 COLLATE latin2_croatian_ci"},

{28,"gbk COLLATE gbk_chinese_ci"},

{29,"cp1257 COLLATE cp1257_lithuanian_ci"},

{30,"latin5 COLLATE latin5_turkish_ci"},

{31,"latin1 COLLATE latin1_german2_ci"},

{32,"armscii8 COLLATE armscii8_general_ci"},

{33,"utf8 COLLATE utf8_general_ci"},

{34,"cp1250 COLLATE cp1250_czech_cs"},

{35,"ucs2 COLLATE ucs2_general_ci"},

{36,"cp866 COLLATE cp866_general_ci"},

{37,"keybcs2 COLLATE keybcs2_general_ci"},

{38,"macce COLLATE macce_general_ci"},

{39,"macroman COLLATE macroman_general_ci"},

{40,"cp852 COLLATE cp852_general_ci"},

{41,"latin7 COLLATE latin7_general_ci"},

{42,"latin7 COLLATE latin7_general_cs"},

{43,"macce COLLATE macce_bin"},

{44,"cp1250 COLLATE cp1250_croatian_ci"},

{45,"utf8mb4 COLLATE utf8mb4_general_ci"},

{46,"utf8mb4 COLLATE utf8mb4_bin"},

{47,"latin1 COLLATE latin1_bin"},

{48,"latin1 COLLATE latin1_general_ci"},

{49,"latin1 COLLATE latin1_general_cs"},

{50,"cp1251 COLLATE cp1251_bin"},

{51,"cp1251 COLLATE cp1251_general_ci"},

{52,"cp1251 COLLATE cp1251_general_cs"},

{53,"macroman COLLATE macroman_bin"},

{54,"utf16 COLLATE utf16_general_ci"},

{55,"utf16 COLLATE utf16_bin"},

{56,"utf16le COLLATE utf16le_general_ci"},

{57,"cp1256 COLLATE cp1256_general_ci"},

{58,"cp1257 COLLATE cp1257_bin"},

{59,"cp1257 COLLATE cp1257_general_ci"},

{60,"utf32 COLLATE utf32_general_ci"},

{61,"utf32 COLLATE utf32_bin"},

{62,"utf16le COLLATE utf16le_bin"},

{63,"binary COLLATE binary"},

{64,"armscii8 COLLATE armscii8_bin"},

{65,"ascii COLLATE ascii_bin"},

{66,"cp1250 COLLATE cp1250_bin"},

{67,"cp1256 COLLATE cp1256_bin"},

{68,"cp866 COLLATE cp866_bin"},

{69,"dec8 COLLATE dec8_bin"},

{70,"greek COLLATE greek_bin"},

{71,"hebrew COLLATE hebrew_bin"},

{72,"hp8 COLLATE hp8_bin"},

{73,"keybcs2 COLLATE keybcs2_bin"},

{74,"koi8r COLLATE koi8r_bin"},

{75,"koi8u COLLATE koi8u_bin"},

{77,"latin2 COLLATE latin2_bin"},

{78,"latin5 COLLATE latin5_bin"},

{79,"latin7 COLLATE latin7_bin"},

{80,"cp850 COLLATE cp850_bin"},

{81,"cp852 COLLATE cp852_bin"},

{82,"swe7 COLLATE swe7_bin"},

{83,"utf8 COLLATE utf8_bin"},

{84,"big5 COLLATE big5_bin"},

{85,"euckr COLLATE euckr_bin"},

{86,"gb2312 COLLATE gb2312_bin"},

{87,"gbk COLLATE gbk_bin"},

{88,"sjis COLLATE sjis_bin"},

{89,"tis620 COLLATE tis620_bin"},

{90,"ucs2 COLLATE ucs2_bin"},

{91,"ujis COLLATE ujis_bin"},

{92,"geostd8 COLLATE geostd8_general_ci"},

{93,"geostd8 COLLATE geostd8_bin"},

{94,"latin1 COLLATE latin1_spanish_ci"},

{95,"cp932 COLLATE cp932_japanese_ci"},

{96,"cp932 COLLATE cp932_bin"},

{97,"eucjpms COLLATE eucjpms_japanese_ci"},

{98,"eucjpms COLLATE eucjpms_bin"},

{99,"cp1250 COLLATE cp1250_polish_ci"},

{101,"utf16 COLLATE utf16_unicode_ci"},

{102,"utf16 COLLATE utf16_icelandic_ci"},

{103,"utf16 COLLATE utf16_latvian_ci"},

{104,"utf16 COLLATE utf16_romanian_ci"},

{105,"utf16 COLLATE utf16_slovenian_ci"},

{106,"utf16 COLLATE utf16_polish_ci"},

{107,"utf16 COLLATE utf16_estonian_ci"},

{108,"utf16 COLLATE utf16_spanish_ci"},

{109,"utf16 COLLATE utf16_swedish_ci"},

{110,"utf16 COLLATE utf16_turkish_ci"},

{111,"utf16 COLLATE utf16_czech_ci"},

{112,"utf16 COLLATE utf16_danish_ci"},

{113,"utf16 COLLATE utf16_lithuanian_ci"},

{114,"utf16 COLLATE utf16_slovak_ci"},

{115,"utf16 COLLATE utf16_spanish2_ci"},

{116,"utf16 COLLATE utf16_roman_ci"},

{117,"utf16 COLLATE utf16_persian_ci"},

{118,"utf16 COLLATE utf16_esperanto_ci"},

{119,"utf16 COLLATE utf16_hungarian_ci"},

{120,"utf16 COLLATE utf16_sinhala_ci"},

{121,"utf16 COLLATE utf16_german2_ci"},

{122,"utf16 COLLATE utf16_croatian_mysql561_ci"},

{123,"utf16 COLLATE utf16_unicode_520_ci"},

{124,"utf16 COLLATE utf16_vietnamese_ci"},

{128,"ucs2 COLLATE ucs2_unicode_ci"},

{129,"ucs2 COLLATE ucs2_icelandic_ci"},

{130,"ucs2 COLLATE ucs2_latvian_ci"},

{131,"ucs2 COLLATE ucs2_romanian_ci"},

{132,"ucs2 COLLATE ucs2_slovenian_ci"},

{133,"ucs2 COLLATE ucs2_polish_ci"},

{134,"ucs2 COLLATE ucs2_estonian_ci"},

{135,"ucs2 COLLATE ucs2_spanish_ci"},

{136,"ucs2 COLLATE ucs2_swedish_ci"},

{137,"ucs2 COLLATE ucs2_turkish_ci"},

{138,"ucs2 COLLATE ucs2_czech_ci"},

{139,"ucs2 COLLATE ucs2_danish_ci"},

{140,"ucs2 COLLATE ucs2_lithuanian_ci"},

{141,"ucs2 COLLATE ucs2_slovak_ci"},

{142,"ucs2 COLLATE ucs2_spanish2_ci"},

{143,"ucs2 COLLATE ucs2_roman_ci"},

{144,"ucs2 COLLATE ucs2_persian_ci"},

{145,"ucs2 COLLATE ucs2_esperanto_ci"},

{146,"ucs2 COLLATE ucs2_hungarian_ci"},

{147,"ucs2 COLLATE ucs2_sinhala_ci"},

{148,"ucs2 COLLATE ucs2_german2_ci"},

{149,"ucs2 COLLATE ucs2_croatian_mysql561_ci"},

{150,"ucs2 COLLATE ucs2_unicode_520_ci"},

{151,"ucs2 COLLATE ucs2_vietnamese_ci"},

{159,"ucs2 COLLATE ucs2_general_mysql500_ci"},

{160,"utf32 COLLATE utf32_unicode_ci"},

{161,"utf32 COLLATE utf32_icelandic_ci"},

{162,"utf32 COLLATE utf32_latvian_ci"},

{163,"utf32 COLLATE utf32_romanian_ci"},

{164,"utf32 COLLATE utf32_slovenian_ci"},

{165,"utf32 COLLATE utf32_polish_ci"},

{166,"utf32 COLLATE utf32_estonian_ci"},

{167,"utf32 COLLATE utf32_spanish_ci"},

{168,"utf32 COLLATE utf32_swedish_ci"},

{169,"utf32 COLLATE utf32_turkish_ci"},

{170,"utf32 COLLATE utf32_czech_ci"},

{171,"utf32 COLLATE utf32_danish_ci"},

{172,"utf32 COLLATE utf32_lithuanian_ci"},

{173,"utf32 COLLATE utf32_slovak_ci"},

{174,"utf32 COLLATE utf32_spanish2_ci"},

{175,"utf32 COLLATE utf32_roman_ci"},

{176,"utf32 COLLATE utf32_persian_ci"},

{177,"utf32 COLLATE utf32_esperanto_ci"},

{178,"utf32 COLLATE utf32_hungarian_ci"},

{179,"utf32 COLLATE utf32_sinhala_ci"},

{180,"utf32 COLLATE utf32_german2_ci"},

{181,"utf32 COLLATE utf32_croatian_mysql561_ci"},

{182,"utf32 COLLATE utf32_unicode_520_ci"},

{183,"utf32 COLLATE utf32_vietnamese_ci"},

{192,"utf8 COLLATE utf8_unicode_ci"},

{193,"utf8 COLLATE utf8_icelandic_ci"},

{194,"utf8 COLLATE utf8_latvian_ci"},

{195,"utf8 COLLATE utf8_romanian_ci"},

{196,"utf8 COLLATE utf8_slovenian_ci"},

{197,"utf8 COLLATE utf8_polish_ci"},

{198,"utf8 COLLATE utf8_estonian_ci"},

{199,"utf8 COLLATE utf8_spanish_ci"},

{200,"utf8 COLLATE utf8_swedish_ci"},

{201,"utf8 COLLATE utf8_turkish_ci"},

{202,"utf8 COLLATE utf8_czech_ci"},

{203,"utf8 COLLATE utf8_danish_ci"},

{204,"utf8 COLLATE utf8_lithuanian_ci"},

{205,"utf8 COLLATE utf8_slovak_ci"},

{206,"utf8 COLLATE utf8_spanish2_ci"},

{207,"utf8 COLLATE utf8_roman_ci"},

{208,"utf8 COLLATE utf8_persian_ci"},

{209,"utf8 COLLATE utf8_esperanto_ci"},

{210,"utf8 COLLATE utf8_hungarian_ci"},

{211,"utf8 COLLATE utf8_sinhala_ci"},

{212,"utf8 COLLATE utf8_german2_ci"},

{213,"utf8 COLLATE utf8_croatian_mysql561_ci"},

{214,"utf8 COLLATE utf8_unicode_520_ci"},

{215,"utf8 COLLATE utf8_vietnamese_ci"},

{223,"utf8 COLLATE utf8_general_mysql500_ci"},

{224,"utf8mb4 COLLATE utf8mb4_unicode_ci"},

{225,"utf8mb4 COLLATE utf8mb4_icelandic_ci"},

{226,"utf8mb4 COLLATE utf8mb4_latvian_ci"},

{227,"utf8mb4 COLLATE utf8mb4_romanian_ci"},

{228,"utf8mb4 COLLATE utf8mb4_slovenian_ci"},

{229,"utf8mb4 COLLATE utf8mb4_polish_ci"},

{230,"utf8mb4 COLLATE utf8mb4_estonian_ci"},

{231,"utf8mb4 COLLATE utf8mb4_spanish_ci"},

{232,"utf8mb4 COLLATE utf8mb4_swedish_ci"},

{233,"utf8mb4 COLLATE utf8mb4_turkish_ci"},

{234,"utf8mb4 COLLATE utf8mb4_czech_ci"},

{235,"utf8mb4 COLLATE utf8mb4_danish_ci"},

{236,"utf8mb4 COLLATE utf8mb4_lithuanian_ci"},

{237,"utf8mb4 COLLATE utf8mb4_slovak_ci"},

{238,"utf8mb4 COLLATE utf8mb4_spanish2_ci"},

{239,"utf8mb4 COLLATE utf8mb4_roman_ci"},

{240,"utf8mb4 COLLATE utf8mb4_persian_ci"},

{241,"utf8mb4 COLLATE utf8mb4_esperanto_ci"},

{242,"utf8mb4 COLLATE utf8mb4_hungarian_ci"},

{243,"utf8mb4 COLLATE utf8mb4_sinhala_ci"},

{244,"utf8mb4 COLLATE utf8mb4_german2_ci"},

{245,"utf8mb4 COLLATE utf8mb4_croatian_mysql561_ci"},

{246,"utf8mb4 COLLATE utf8mb4_unicode_520_ci"},

{247,"utf8mb4 COLLATE utf8mb4_vietnamese_ci"},

{576,"utf8 COLLATE utf8_croatian_ci"},

{577,"utf8 COLLATE utf8_myanmar_ci"},

{578,"utf8 COLLATE utf8_thai_520_w2"},

{608,"utf8mb4 COLLATE utf8mb4_croatian_ci"},

{609,"utf8mb4 COLLATE utf8mb4_myanmar_ci"},

{610,"utf8mb4 COLLATE utf8mb4_thai_520_w2"},

{640,"ucs2 COLLATE ucs2_croatian_ci"},

{641,"ucs2 COLLATE ucs2_myanmar_ci"},

{642,"ucs2 COLLATE ucs2_thai_520_w2"},

{672,"utf16 COLLATE utf16_croatian_ci"},

{673,"utf16 COLLATE utf16_myanmar_ci"},

{674,"utf16 COLLATE utf16_thai_520_w2"},

{736,"utf32 COLLATE utf32_croatian_ci"},

{737,"utf32 COLLATE utf32_myanmar_ci"},

{738,"utf32 COLLATE utf32_thai_520_w2"},

{1025,"big5 COLLATE big5_chinese_nopad_ci"},

{1027,"dec8 COLLATE dec8_swedish_nopad_ci"},

{1028,"cp850 COLLATE cp850_general_nopad_ci"},

{1030,"hp8 COLLATE hp8_english_nopad_ci"},

{1031,"koi8r COLLATE koi8r_general_nopad_ci"},

{1032,"latin1 COLLATE latin1_swedish_nopad_ci"},

{1033,"latin2 COLLATE latin2_general_nopad_ci"},

{1034,"swe7 COLLATE swe7_swedish_nopad_ci"},

{1035,"ascii COLLATE ascii_general_nopad_ci"},

{1036,"ujis COLLATE ujis_japanese_nopad_ci"},

{1037,"sjis COLLATE sjis_japanese_nopad_ci"},

{1040,"hebrew COLLATE hebrew_general_nopad_ci"},

{1042,"tis620 COLLATE tis620_thai_nopad_ci"},

{1043,"euckr COLLATE euckr_korean_nopad_ci"},

{1046,"koi8u COLLATE koi8u_general_nopad_ci"},

{1048,"gb2312 COLLATE gb2312_chinese_nopad_ci"},

{1049,"greek COLLATE greek_general_nopad_ci"},

{1050,"cp1250 COLLATE cp1250_general_nopad_ci"},

{1052,"gbk COLLATE gbk_chinese_nopad_ci"},

{1054,"latin5 COLLATE latin5_turkish_nopad_ci"},

{1056,"armscii8 COLLATE armscii8_general_nopad_ci"},

{1057,"utf8 COLLATE utf8_general_nopad_ci"},

{1059,"ucs2 COLLATE ucs2_general_nopad_ci"},

{1060,"cp866 COLLATE cp866_general_nopad_ci"},

{1061,"keybcs2 COLLATE keybcs2_general_nopad_ci"},

{1062,"macce COLLATE macce_general_nopad_ci"},

{1063,"macroman COLLATE macroman_general_nopad_ci"},

{1064,"cp852 COLLATE cp852_general_nopad_ci"},

{1065,"latin7 COLLATE latin7_general_nopad_ci"},

{1067,"macce COLLATE macce_nopad_bin"},

{1069,"utf8mb4 COLLATE utf8mb4_general_nopad_ci"},

{1070,"utf8mb4 COLLATE utf8mb4_nopad_bin"},

{1071,"latin1 COLLATE latin1_nopad_bin"},

{1074,"cp1251 COLLATE cp1251_nopad_bin"},

{1075,"cp1251 COLLATE cp1251_general_nopad_ci"},

{1077,"macroman COLLATE macroman_nopad_bin"},

{1078,"utf16 COLLATE utf16_general_nopad_ci"},

{1079,"utf16 COLLATE utf16_nopad_bin"},

{1080,"utf16le COLLATE utf16le_general_nopad_ci"},

{1081,"cp1256 COLLATE cp1256_general_nopad_ci"},

{1082,"cp1257 COLLATE cp1257_nopad_bin"},

{1083,"cp1257 COLLATE cp1257_general_nopad_ci"},

{1084,"utf32 COLLATE utf32_general_nopad_ci"},

{1085,"utf32 COLLATE utf32_nopad_bin"},

{1086,"utf16le COLLATE utf16le_nopad_bin"},

{1088,"armscii8 COLLATE armscii8_nopad_bin"},

{1089,"ascii COLLATE ascii_nopad_bin"},

{1090,"cp1250 COLLATE cp1250_nopad_bin"},

{1091,"cp1256 COLLATE cp1256_nopad_bin"},

{1092,"cp866 COLLATE cp866_nopad_bin"},

{1093,"dec8 COLLATE dec8_nopad_bin"},

{1094,"greek COLLATE greek_nopad_bin"},

{1095,"hebrew COLLATE hebrew_nopad_bin"},

{1096,"hp8 COLLATE hp8_nopad_bin"},

{1097,"keybcs2 COLLATE keybcs2_nopad_bin"},

{1098,"koi8r COLLATE koi8r_nopad_bin"},

{1099,"koi8u COLLATE koi8u_nopad_bin"},

{1101,"latin2 COLLATE latin2_nopad_bin"},

{1102,"latin5 COLLATE latin5_nopad_bin"},

{1103,"latin7 COLLATE latin7_nopad_bin"},

{1104,"cp850 COLLATE cp850_nopad_bin"},

{1105,"cp852 COLLATE cp852_nopad_bin"},

{1106,"swe7 COLLATE swe7_nopad_bin"},

{1107,"utf8 COLLATE utf8_nopad_bin"},

{1108,"big5 COLLATE big5_nopad_bin"},

{1109,"euckr COLLATE euckr_nopad_bin"},

{1110,"gb2312 COLLATE gb2312_nopad_bin"},

{1111,"gbk COLLATE gbk_nopad_bin"},

{1112,"sjis COLLATE sjis_nopad_bin"},

{1113,"tis620 COLLATE tis620_nopad_bin"},

{1114,"ucs2 COLLATE ucs2_nopad_bin"},

{1115,"ujis COLLATE ujis_nopad_bin"},

{1116,"geostd8 COLLATE geostd8_general_nopad_ci"},

{1117,"geostd8 COLLATE geostd8_nopad_bin"},

{1119,"cp932 COLLATE cp932_japanese_nopad_ci"},

{1120,"cp932 COLLATE cp932_nopad_bin"},

{1121,"eucjpms COLLATE eucjpms_japanese_nopad_ci"},

{1122,"eucjpms COLLATE eucjpms_nopad_bin"},

{1125,"utf16 COLLATE utf16_unicode_nopad_ci"},

{1147,"utf16 COLLATE utf16_unicode_520_nopad_ci"},

{1152,"ucs2 COLLATE ucs2_unicode_nopad_ci"},

{1174,"ucs2 COLLATE ucs2_unicode_520_nopad_ci"},

{1184,"utf32 COLLATE utf32_unicode_nopad_ci"},

{1206,"utf32 COLLATE utf32_unicode_520_nopad_ci"},

{1216,"utf8 COLLATE utf8_unicode_nopad_ci"},

{1238,"utf8 COLLATE utf8_unicode_520_nopad_ci"},

{1248,"utf8mb4 COLLATE utf8mb4_unicode_nopad_ci"},

{1270,"utf8mb4 COLLATE utf8mb4_unicode_520_nopad_ci"},

{0, NULL}

};

static value_string_ext mariadb_collation_vals_ext = VALUE_STRING_EXT_INIT(mariadb_collation_vals);

typedef struct {

const char *charset;

unsigned encoding;

} charset_encoding_t;