Re: [GENERAL] convert(USING utf8_to_iso_8859_15) on Windows

[Tom Lane]

"Pierre Thibaudeau" <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend