Re: Unicode Variation Selector and Combining character

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.