On 01.06.22 08:15, 荒井元成 wrote:
D209007=# select char_length(U&'\+0066FE' || U&'\+0E0103') ;char_length ------------- 2 (1 行) I expect length 1.
The char_length function is defined to return the length in characters, so 2 is the correct answer. What you appear to be looking for is length in glyphs or length in graphemes or display width, or something like that. There is no built-in server side function for that.
It looks like psql is getting the display width wrong, but that's a separate issue.
