ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp> writes:
> Yes, I only used the 'disjoint representations for first-bytes and
> not-first-bytes of MB characters' feature in UTF8. Other encodings
> allows both [AB] and [BA] for MB character patterns. UTF8Match() does
> not cope with those encodings; If we have '[AB][AB]' in a table and
> search it with LIKE '%[BA]%', we judge that they are matched by mistake.
AFAICS, the patch does *not* make that mistake because % will not
advance over a fractional character.
regards, tom lane