On Mon, Dec 03, 2007 at 12:51:27PM -0500, Josh Harrison <joshques@xxxxxxxxx> wrote a message of 63 lines which said: > The encoding you selected (UTF8) and the encoding that the > selected locale uses (LATIN1) do not match. Indeed. > Rerun initdb and either do not specify an encoding explicitly, or > choose a matching combination. That's the right solution. % initdb --encoding=UTF8 --locale=fr_FR.UTF8 If you read French, see http://www.bortzmeyer.org/postgresql-unicode.html ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend