Sample Header Ad - 728x90

Why is the character set for the uca1400_ai_ci collation NULL?

0 votes
1 answer
1104 views
I've been working with database collations of late. I generally don't like ambiguous queries such as SHOW COLLATION so I eventually found the source via the following query: SELECT * FROM information_schema.COLLATIONS ORDER BY CHARACTER_SET_NAME ASC, COLLATION_NAME ASC; I now have the option to update the collation to uca1400_ai_ci however the associated character set value is NULL. Why is the uca1400_ai_ci NULL and what, if any considerations should I have while updating from the character set utf8mb4 and collation utf8mb4_unicode_520_ci?
Asked by John (769 rep)
Jul 19, 2024, 01:43 AM
Last activity: Aug 4, 2025, 06:01 PM