On 30.05.22 02:27, 荒井元成 wrote:
I tried it on PostgreSQL 13. If you use the Unicode Variation Selector
and Combining Character
, the base character and the Variation selector will be 2 in length.
Since it will be one character on the display, we expect it to be one in
length. Please provide a function corresponding to the unicode variasion
selector. I hope It is supposed to be provided as an extension.
The functions that need to be supported are as follows:
char_length|character_length|substring|trim|btrim|left
|length|lpad|ltrim|regexp_match|regexp_matches
|regexp_replace|regexp_split_to_array|regexp_split_to_table
|replace|reverse|right|rpad|rtrim|split_part|strpos|substr|starts_with
Please show a test case of what you mean. For example,
select char_length(...) returns X but should return Y
Examples with Unicode escapes (U&'\NNNN...') would be the most robust.
