Re: convert(USING utf8_to_iso_8859_15) on Windows - Mailing list pgsql-general

"Pierre Thibaudeau" <pierdeux@gmail.com> writes:
> My setup is as follows:
> PostgreSQL 8.2.1 on WindowsXP
> The database has UTF8 encoding.
> SHOW lc_ctype; gives: "French_Canada.1252"

I'm not sure about any Windows-specific issues, but in general it's a
really bad idea to be using lc_collate or lc_ctype that is incompatible
with the database encoding.

            regards, tom lane