utf8_general_ci_legacy
This page is part of MariaDB's Documentation.
The parent of this page is: Collations for MariaDB Xpand
Topics on this page:
Overview
A deprecated collation for the utf8 character set
DETAILS
Is Default? No
EXAMPLES
CREATE TABLE collate_example1 (
name VARCHAR(32) CHARSET utf8,
description VARCHAR(64) CHARSET utf8 COLLATE utf8_general_ci_legacy
);
CREATE TABLE collate_example2 (
name VARCHAR(32),
description VARCHAR(64)
) DEFAULT CHARSET utf8, DEFAULT COLLATE utf8_general_ci_legacy;
SET SESSION collation_connection = 'utf8_general_ci_legacy';