ITAGAKI Takahiro <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly