mariadb/strings/ctype-uca1400.h
Monty 7fcaab7aaa MDEV-20912 Add support for utf8mb4_0900_* collations in MariaDB Server
This is done by mapping most of the existing MySQL unicode 0900 collations
to MariadB 1400 unicode collations. The assumption is that 1400 is a super
set of 0900 for all practical purposes.

I also added a new function 'compare_collations()' and changed most code
to use this instead of comparing character sets directly.
This enables one to seamlessly mix-and-match the corresponding 0900 and
1400 sets. Field comparision and alter table treats the character sets
as identical.

All MySQL 8.0 0900 collations are supported except:
- utf8mb4_ja_0900_as_cs
- utf8mb4_ja_0900_as_cs_ks
- utf8mb4_ru_0900_as_cs
- utf8mb4_zh_0900_as_cs

These do not have corresponding entries in the MariadB 01400 collations.

Other things:
- Added COMMENT colum to information_schema.collations. For utf8mb4_0900
  colletions it contains the corresponding alias collation.
2024-12-28 10:23:49 +02:00

253 lines
7.9 KiB
C

#ifndef CTYPE_UCA_1400_H
#define CTYPE_UCA_1400_H
/* Copyright (c) 2021, MariaDB
This library is free software; you can redistribute it and/or
modify it under the terms of the GNU Library General Public
License as published by the Free Software Foundation; version 2
of the License.
This library is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
Library General Public License for more details.
You should have received a copy of the GNU Library General Public
License along with this library; if not, write to the Free
Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston,
MA 02110-1335 USA */
/*
17000..187FF; Tangut [6144]
18800..18AFF; Tangut Components [768]
18D00..18D7F; Tangut Supplement [128]
*/
static inline my_bool
my_uca_1400_is_assigned_tangut(my_wc_t code)
{
return (code >= 0x17000 && code <= 0x187FF) ||
(code >= 0x18800 && code <= 0x18AFF) ||
(code >= 0x18D00 && code <= 0x18D7F);
}
static inline MY_UCA_IMPLICIT_WEIGHT
my_uca_1400_implicit_weight_primary_tangut(my_wc_t code)
{
MY_UCA_IMPLICIT_WEIGHT res;
res.weight[0]= 0xFB00;
res.weight[1]= (uint16) (code - 0x17000) | 0x8000;
return res;
}
/*
1B170..1B2FF; Nushu [400]
*/
static inline my_bool
my_uca_1400_is_assigned_nushu(my_wc_t code)
{
return code >= 0x1B170 && code <= 0x1B2FF;
}
static inline MY_UCA_IMPLICIT_WEIGHT
my_uca_1400_implicit_weight_primary_nushu(my_wc_t code)
{
MY_UCA_IMPLICIT_WEIGHT res;
res.weight[0]= 0xFB01;
res.weight[1]= (uint16) (code - 0x1B170) | 0x8000;
return res;
}
/*
18B00..18CFF; Khitan Small Script [512]
*/
static inline my_bool
my_uca_1400_is_assigned_khitan_small_script(my_wc_t code)
{
return code >= 0x18B00 && code <= 0x18CFF;
}
static inline MY_UCA_IMPLICIT_WEIGHT
my_uca_1400_implicit_weight_primary_khitan(my_wc_t code)
{
MY_UCA_IMPLICIT_WEIGHT res;
res.weight[0]= 0xFB02;
res.weight[1]= (uint16) (code - 0x18B00) | 0x8000;
return res;
}
/*
Unified_Ideograph=True AND
((Block=CJK_Unified_Ideograph) OR (Block=CJK_Compatibility_Ideographs))
https://www.unicode.org/Public/14.0.0/ucd/Blocks.txt
4E00..9FFF; CJK Unified Ideographs
F900..FAFF; CJK Compatibility Ideographs
https://www.unicode.org/Public/14.0.0/ucd/PropList.txt
4E00..9FFF ; Unified_Ideograph # Lo [20992] CJK UNIFIED IDEOGRAPH-4E00..CJK UNIFIED IDEOGRAPH-9FFF
FA0E..FA0F ; Unified_Ideograph # Lo [2] CJK COMPATIBILITY IDEOGRAPH-FA0E..CJK COMPATIBILITY IDEOGRAPH-FA0F
FA11 ; Unified_Ideograph # Lo CJK COMPATIBILITY IDEOGRAPH-FA11
FA13..FA14 ; Unified_Ideograph # Lo [2] CJK COMPATIBILITY IDEOGRAPH-FA13..CJK COMPATIBILITY IDEOGRAPH-FA14
FA1F ; Unified_Ideograph # Lo CJK COMPATIBILITY IDEOGRAPH-FA1F
FA21 ; Unified_Ideograph # Lo CJK COMPATIBILITY IDEOGRAPH-FA21
FA23..FA24 ; Unified_Ideograph # Lo [2] CJK COMPATIBILITY IDEOGRAPH-FA23..CJK COMPATIBILITY IDEOGRAPH-FA24
FA27..FA29 ; Unified_Ideograph # Lo [3] CJK COMPATIBILITY IDEOGRAPH-FA27..CJK COMPATIBILITY IDEOGRAPH-FA29
*/
static inline my_bool
my_uca_1400_is_core_han_unified_ideograph(my_wc_t code)
{
return (code >= 0x4E00 && code <= 0x9FFF) ||
(code >= 0xFA0E && code <= 0xFA0F) ||
(code == 0xFA11) ||
(code >= 0xFA13 && code <= 0xFA14) ||
(code == 0xFA1F) ||
(code == 0xFA21) ||
(code >= 0xFA23 && code <= 0xFA24) ||
(code >= 0xFA27 && code <= 0xFA29);
}
/*
(Unified_Ideograph=True AND NOT
((Block=CJK_Unified_Ideograph) OR (Block=CJK_Compatibility_Ideographs))
https://www.unicode.org/Public/14.0.0/ucd/Blocks.txt
3400..4DBF; CJK Unified Ideographs Extension A
20000..2A6DF; CJK Unified Ideographs Extension B
2A700..2B73F; CJK Unified Ideographs Extension C
2B740..2B81F; CJK Unified Ideographs Extension D
2B820..2CEAF; CJK Unified Ideographs Extension E
2CEB0..2EBEF; CJK Unified Ideographs Extension F
30000..3134F; CJK Unified Ideographs Extension G
https://www.unicode.org/Public/14.0.0/ucd/PropList.txt
3400..4DBF ; Unified_Ideograph # Lo [6592] CJK UNIFIED IDEOGRAPH-3400..CJK UNIFIED IDEOGRAPH-4DBF
20000..2A6DF ; Unified_Ideograph # Lo [42720] CJK UNIFIED IDEOGRAPH-20000..CJK UNIFIED IDEOGRAPH-2A6DF
2A700..2B738 ; Unified_Ideograph # Lo [4153] CJK UNIFIED IDEOGRAPH-2A700..CJK UNIFIED IDEOGRAPH-2B738
2B740..2B81D ; Unified_Ideograph # Lo [222] CJK UNIFIED IDEOGRAPH-2B740..CJK UNIFIED IDEOGRAPH-2B81D
2B820..2CEA1 ; Unified_Ideograph # Lo [5762] CJK UNIFIED IDEOGRAPH-2B820..CJK UNIFIED IDEOGRAPH-2CEA1
2CEB0..2EBE0 ; Unified_Ideograph # Lo [7473] CJK UNIFIED IDEOGRAPH-2CEB0..CJK UNIFIED IDEOGRAPH-2EBE0
30000..3134A ; Unified_Ideograph # Lo [4939] CJK UNIFIED IDEOGRAPH-30000..CJK UNIFIED IDEOGRAPH-3134A
*/
static inline my_bool
my_uca_1400_is_other_han_unified_ideograph(my_wc_t code)
{
return (code >= 0x3400 && code <= 0x4DBF) ||
(code >= 0x20000 && code <= 0x2A6DF) ||
(code >= 0x2A700 && code <= 0x2B738) ||
(code >= 0x2B740 && code <= 0x2B81D) ||
(code >= 0x2B820 && code <= 0x2CEA1) ||
(code >= 0x2CEB0 && code <= 0x2EBE0) ||
(code >= 0x30000 && code <= 0x3134A);
}
/*
See section "Computing Implicit Weights" in
https://unicode.org/reports/tr10/#Values_For_Base_Table
*/
static inline MY_UCA_IMPLICIT_WEIGHT
my_uca_1400_implicit_weight_primary(my_wc_t code)
{
if (my_uca_1400_is_core_han_unified_ideograph(code))
return my_uca_implicit_weight_primary_default(0xFB40, code);
if (my_uca_1400_is_other_han_unified_ideograph(code))
return my_uca_implicit_weight_primary_default(0xFB80, code);
if (my_uca_1400_is_assigned_tangut(code))
return my_uca_1400_implicit_weight_primary_tangut(code);
if (my_uca_1400_is_assigned_nushu(code))
return my_uca_1400_implicit_weight_primary_nushu(code);
if (my_uca_1400_is_assigned_khitan_small_script(code))
return my_uca_1400_implicit_weight_primary_khitan(code);
/* Unassigned - Any other code point */
return my_uca_implicit_weight_primary_default(0xFBC0, code);
}
#define MY_UCA1400_COLLATION_ID_POSSIBLE_MIN 2048
#define MY_UCA1400_COLLATION_ID_POSSIBLE_MAX 4095
static inline my_bool
my_collation_id_is_uca1400(uint id)
{
return (my_bool) (id >= MY_UCA1400_COLLATION_ID_POSSIBLE_MIN &&
id <= MY_UCA1400_COLLATION_ID_POSSIBLE_MAX);
}
/*
UCA1400 collation ID:
1000 0000 0000 0x800 2048
1111 1111 1111 0xFFF 4095
1ccc tttt tPST
c - charset ID (utf8mb3=0, utf8mb4=1, ucs2=2, utf16=3, utf32=4)
p - PAD/NO PAD
S - secondary level is enabled
T - tertiary level is enabled
*/
static inline my_cs_encoding_t
my_uca1400_collation_id_to_charset_id(uint id)
{
return (my_cs_encoding_t) ((id >> 8) & 0x07);
}
static inline uint
my_uca1400_collation_id_to_tailoring_id(uint id)
{
return (id >> 3) & 0x1F;
}
static inline my_bool
my_uca1400_collation_id_to_nopad_flag(uint id)
{
return (my_bool) ((id >> 2) & 0x01);
}
static inline my_bool
my_uca1400_collation_id_to_secondary_level_flag(uint id)
{
return (my_bool) ((id >> 1) & 0x01);
}
static inline my_bool
my_uca1400_collation_id_to_tertiary_level_flag(uint id)
{
return (my_bool) ((id >> 0) & 0x01);
}
uint
my_uca1400_make_builtin_collation_id(my_cs_encoding_t charset_id,
uint tailoring_id,
my_bool nopad,
my_bool secondary_level,
my_bool tertiary_level);
my_bool
my_uca1400_collation_definition_init(MY_CHARSET_LOADER *loader,
struct charset_info_st *dst,
uint collation_id);
#define MY_UCA1400_COLLATION_DEFINITION_COUNT 26
my_bool mysql_utf8mb4_0900_collation_definitions_add();
#endif /* CTYPE_UCA_1400_H */