[email protected] writes: > encoding is set correctly. To what?
> While ilike works correctly ~* doesn't why ? ~* is known to have issues in multibyte encodings (eg UTF8). Fixing this is on the TODO list, but nobody's thought of a reasonably clean fix yet. There is a partial solution in place for 9.0 --- it should work for UTF8, though not for other multibyte encodings. If you're feeling desperate you could try backpatching this commit: http://archives.postgresql.org/message-id/[email protected] However the path of least resistance might be to use a single-byte encoding in your database, such as LATIN1. regards, tom lane -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
