Re: Character encoding and string matches

    Richard van den Berg wrote:

> During the
> pg_restore, it complained about failing to create several indexes
> because of duplicates. Inspecting these cases showed that the bogus
> characters are to blame. It seems that these characters (that are
> probably not defined in LATIN1) are now turned into wildcards: they will
> match any other character. Is this an expected result from running a non
> SQL_ASCII database?

It should depend on the locale. Can you tell the results of
`show lc_ctype` and `show lc_collate`?

--
 Daniel
 PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org