[MDEV-34478] SHOW COLLATION shows strange NULLs - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Not a Bug
Affects Version/s: 11.4.2
Fix Version/s: N/A
Component/s: Character Sets
Labels:
- collation

Description

MariaDB [(none)]> show collation ;

...

| uca1400_ai_ci                  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_ai_cs                  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_as_ci                  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_as_cs                  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_nopad_ai_ci            | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_nopad_ai_cs            | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_nopad_as_ci            | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_nopad_as_cs            | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_icelandic_ai_ci        | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_icelandic_ai_cs        | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_icelandic_as_ci        | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_icelandic_as_cs        | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_icelandic_nopad_ai_ci  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_icelandic_nopad_ai_cs  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_icelandic_nopad_as_ci  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_icelandic_nopad_as_cs  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_latvian_ai_ci          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_latvian_ai_cs          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_latvian_as_ci          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_latvian_as_cs          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_latvian_nopad_ai_ci    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_latvian_nopad_ai_cs    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_latvian_nopad_as_ci    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_latvian_nopad_as_cs    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_romanian_ai_ci         | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_romanian_ai_cs         | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_romanian_as_ci         | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_romanian_as_cs         | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_romanian_nopad_ai_ci   | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_romanian_nopad_ai_cs   | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_romanian_nopad_as_ci   | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_romanian_nopad_as_cs   | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_slovenian_ai_ci        | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_slovenian_ai_cs        | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_slovenian_as_ci        | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_slovenian_as_cs        | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_slovenian_nopad_ai_ci  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_slovenian_nopad_ai_cs  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_slovenian_nopad_as_ci  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_slovenian_nopad_as_cs  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_polish_ai_ci           | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_polish_ai_cs           | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_polish_as_ci           | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_polish_as_cs           | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_polish_nopad_ai_ci     | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_polish_nopad_ai_cs     | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_polish_nopad_as_ci     | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_polish_nopad_as_cs     | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_estonian_ai_ci         | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_estonian_ai_cs         | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_estonian_as_ci         | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_estonian_as_cs         | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_estonian_nopad_ai_ci   | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_estonian_nopad_ai_cs   | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_estonian_nopad_as_ci   | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_estonian_nopad_as_cs   | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_spanish_ai_ci          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_spanish_ai_cs          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_spanish_as_ci          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_spanish_as_cs          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_spanish_nopad_ai_ci    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_spanish_nopad_ai_cs    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_spanish_nopad_as_ci    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_spanish_nopad_as_cs    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_swedish_ai_ci          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_swedish_ai_cs          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_swedish_as_ci          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_swedish_as_cs          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_swedish_nopad_ai_ci    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_swedish_nopad_ai_cs    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_swedish_nopad_as_ci    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_swedish_nopad_as_cs    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_turkish_ai_ci          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_turkish_ai_cs          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_turkish_as_ci          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_turkish_as_cs          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_turkish_nopad_ai_ci    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_turkish_nopad_ai_cs    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_turkish_nopad_as_ci    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_turkish_nopad_as_cs    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_czech_ai_ci            | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_czech_ai_cs            | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_czech_as_ci            | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_czech_as_cs            | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_czech_nopad_ai_ci      | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_czech_nopad_ai_cs      | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_czech_nopad_as_ci      | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_czech_nopad_as_cs      | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_danish_ai_ci           | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_danish_ai_cs           | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_danish_as_ci           | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_danish_as_cs           | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_danish_nopad_ai_ci     | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_danish_nopad_ai_cs     | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_danish_nopad_as_ci     | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_danish_nopad_as_cs     | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_lithuanian_ai_ci       | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_lithuanian_ai_cs       | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_lithuanian_as_ci       | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_lithuanian_as_cs       | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_lithuanian_nopad_ai_ci | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_lithuanian_nopad_ai_cs | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_lithuanian_nopad_as_ci | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_lithuanian_nopad_as_cs | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_slovak_ai_ci           | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_slovak_ai_cs           | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_slovak_as_ci           | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_slovak_as_cs           | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_slovak_nopad_ai_ci     | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_slovak_nopad_ai_cs     | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_slovak_nopad_as_ci     | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_slovak_nopad_as_cs     | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_spanish2_ai_ci         | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_spanish2_ai_cs         | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_spanish2_as_ci         | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_spanish2_as_cs         | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_spanish2_nopad_ai_ci   | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_spanish2_nopad_ai_cs   | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_spanish2_nopad_as_ci   | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_spanish2_nopad_as_cs   | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_roman_ai_ci            | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_roman_ai_cs            | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_roman_as_ci            | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_roman_as_cs            | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_roman_nopad_ai_ci      | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_roman_nopad_ai_cs      | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_roman_nopad_as_ci      | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_roman_nopad_as_cs      | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_persian_ai_ci          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_persian_ai_cs          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_persian_as_ci          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_persian_as_cs          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_persian_nopad_ai_ci    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_persian_nopad_ai_cs    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_persian_nopad_as_ci    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_persian_nopad_as_cs    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_esperanto_ai_ci        | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_esperanto_ai_cs        | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_esperanto_as_ci        | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_esperanto_as_cs        | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_esperanto_nopad_ai_ci  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_esperanto_nopad_ai_cs  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_esperanto_nopad_as_ci  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_esperanto_nopad_as_cs  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_hungarian_ai_ci        | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_hungarian_ai_cs        | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_hungarian_as_ci        | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_hungarian_as_cs        | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_hungarian_nopad_ai_ci  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_hungarian_nopad_ai_cs  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_hungarian_nopad_as_ci  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_hungarian_nopad_as_cs  | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_sinhala_ai_ci          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_sinhala_ai_cs          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_sinhala_as_ci          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_sinhala_as_cs          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_sinhala_nopad_ai_ci    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_sinhala_nopad_ai_cs    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_sinhala_nopad_as_ci    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_sinhala_nopad_as_cs    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_german2_ai_ci          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_german2_ai_cs          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_german2_as_ci          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_german2_as_cs          | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_german2_nopad_ai_ci    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_german2_nopad_ai_cs    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_german2_nopad_as_ci    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_german2_nopad_as_cs    | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_vietnamese_ai_ci       | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_vietnamese_ai_cs       | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_vietnamese_as_ci       | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_vietnamese_as_cs       | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_vietnamese_nopad_ai_ci | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_vietnamese_nopad_ai_cs | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_vietnamese_nopad_as_ci | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_vietnamese_nopad_as_cs | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_croatian_ai_ci         | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_croatian_ai_cs         | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_croatian_as_ci         | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_croatian_as_cs         | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_croatian_nopad_ai_ci   | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_croatian_nopad_ai_cs   | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_croatian_nopad_as_ci   | NULL     | NULL | NULL    | Yes      |       8 |

| uca1400_croatian_nopad_as_cs   | NULL     | NULL | NULL    | Yes      |       8 |

...

I only included the rows that show the problem.

Attachments

Issue Links

is caused by

MDEV-27009 Add UCA-14.0.0 collations

Closed

Activity

Ascending order - Click to sort in descending order

Daniel Black added a comment - 2024-06-27 14:01

The UCA1400 collations map to multiple character sets for the first time hence a logical result is NULL.

you can join https://mariadb.com/kb/en/information-schema-collations-table/ with the https://mariadb.com/kb/en/information-schema-collation_character_set_applicability-table/ table list all the character sets for any of these uca1400 collations.

Daniel Black added a comment - 2024-06-27 14:01 The UCA1400 collations map to multiple character sets for the first time hence a logical result is NULL. you can join https://mariadb.com/kb/en/information-schema-collations-table/ with the https://mariadb.com/kb/en/information-schema-collation_character_set_applicability-table/ table list all the character sets for any of these uca1400 collations.

Sergei Golubchik added a comment - 2024-06-27 14:53

See INFORMATION_SCHEMA.COLLATIONS changes in ~~MDEV-27009~~

Sergei Golubchik added a comment - 2024-06-27 14:53 See INFORMATION_SCHEMA.COLLATIONS changes in MDEV-27009

Vladislav Vaintroub added a comment - 2024-06-27 15:58 - edited

This confused not only f_razzoli, but also some software in ~~MDEV-31608~~, with owners of this software (MySQL Connector/NET , owner Oracle) outright refusing to apply any fixes.

So the session variable old_mode got NO_NULL_COLLATION_IDS which was invented specifically to workaround it. Maybe f_razzoli can give it a try.

Vladislav Vaintroub added a comment - 2024-06-27 15:58 - edited This confused not only f_razzoli , but also some software in MDEV-31608 , with owners of this software (MySQL Connector/NET , owner Oracle) outright refusing to apply any fixes. So the session variable old_mode got NO_NULL_COLLATION_IDS which was invented specifically to workaround it. Maybe f_razzoli can give it a try.

Daniel Black added a comment - 2024-06-28 00:56

Thanks wlad,

MariaDB [(none)]> set old_mode='NO_NULL_COLLATION_IDS';

Query OK, 0 rows affected, 1 warning (0.000 sec)

MariaDB [(none)]> pager grep uca1400_ai_ci

PAGER set to 'grep uca1400_ai_ci'

MariaDB [(none)]> show collation;

| uca1400_ai_ci                  | utf8mb3  | 2048 |         | Yes      |       8 |

| uca1400_ai_ci                  | ucs2     | 2560 |         | Yes      |       8 |

| uca1400_ai_ci                  | utf8mb4  | 2304 |         | Yes      |       8 |

| uca1400_ai_ci                  | utf16    | 2816 |         | Yes      |       8 |

| uca1400_ai_ci                  | utf32    | 3072 |         | Yes      |       8 |

Daniel Black added a comment - 2024-06-28 00:56 Thanks wlad , MariaDB [(none)]> set old_mode='NO_NULL_COLLATION_IDS'; Query OK, 0 rows affected, 1 warning (0.000 sec) MariaDB [(none)]> pager grep uca1400_ai_ci PAGER set to 'grep uca1400_ai_ci' MariaDB [(none)]> show collation; | uca1400_ai_ci | utf8mb3 | 2048 | | Yes | 8 | | uca1400_ai_ci | ucs2 | 2560 | | Yes | 8 | | uca1400_ai_ci | utf8mb4 | 2304 | | Yes | 8 | | uca1400_ai_ci | utf16 | 2816 | | Yes | 8 | | uca1400_ai_ci | utf32 | 3072 | | Yes | 8 |

Federico Razzoli added a comment - 2024-06-29 02:06

Thanks for explaining.

It's nice to have NO_NULL_COLLATION_IDS, but I understand that all old_mode flags are meant to be removed at some point. Correct?

I might be missing something, but I think that in this example NULLs are not justified:

SHOW COLLATION LIKE 'utf8mb4%';

Federico Razzoli added a comment - 2024-06-29 02:06 Thanks for explaining. It's nice to have NO_NULL_COLLATION_IDS, but I understand that all old_mode flags are meant to be removed at some point. Correct? I might be missing something, but I think that in this example NULLs are not justified: SHOW COLLATION LIKE 'utf8mb4%';

Sergei Golubchik added a comment - 2024-07-01 19:47

The logic here that collation as such does not have an id. Collation is how to compare characters, where 'a' is less than, greater than, or equal to 'ä'. Character set is how to store characters, whether 'ä' is x'E4' or x'C3A4'.

Every valid character set / collation pair has a unique id. But in 10.10 MariaDB has collations that apply to many character sets. For example, collation uca1400_latvian_ai_ci applies to utf8mb4, to utf16, utf32, etc. In all these different character sets you'll have exactly the same character comparison rules, because it's exactly the same collation.

So since 10.10 collations no longer have unique ids, because since 10.10 collation name no longer have to include a character set.

Sergei Golubchik added a comment - 2024-07-01 19:47 The logic here that collation as such does not have an id. Collation is how to compare characters, where 'a' is less than, greater than, or equal to 'ä'. Character set is how to store characters, whether 'ä' is x'E4' or x'C3A4' . Every valid character set / collation pair has a unique id. But in 10.10 MariaDB has collations that apply to many character sets. For example, collation uca1400_latvian_ai_ci applies to utf8mb4, to utf16, utf32, etc. In all these different character sets you'll have exactly the same character comparison rules, because it's exactly the same collation. So since 10.10 collations no longer have unique ids, because since 10.10 collation name no longer have to include a character set.

Federico Razzoli added a comment - 2024-07-02 00:25

But if I run

SHOW COLLATION LIKE 'utf8mb4%';

I don't get only the collations whose names start with utf8mb4. I get collations that refer to utf8mb4.
I think I should see the relevant values for Charset and Default (and probably Compiled).

Federico Razzoli added a comment - 2024-07-02 00:25 But if I run SHOW COLLATION LIKE 'utf8mb4%'; I don't get only the collations whose names start with utf8mb4. I get collations that refer to utf8mb4. I think I should see the relevant values for Charset and Default (and probably Compiled).

People

Assignee:: Unassigned

Reporter:: Federico Razzoli

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2024-06-27 12:55

Updated:: 2024-07-02 00:25

Resolved:: 2024-06-27 14:51

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server