Holger Jakobs <holger@jakobs.com> writes:
> It's totally correct that the two characters are still two characters.
> You would have to normalize the string first, so that the combination
> becomes one character.
Yeah. In principle the normalize() function ought to do this for
you. But it doesn't seem to shorten the given example for me;
I'm not sure if that means the example is incorrect, or if it's
a bug in normalize().
u8=# select octet_length(U&'\+008FBA' || U&'\+0E0102');
octet_length
--------------
7
(1 row)
u8=# select octet_length(normalize(U&'\+008FBA' || U&'\+0E0102'));
octet_length
--------------
7
(1 row)
regards, tom lane