On Wednesday 28 December 2005 15:58, Tom Lane wrote: > Gary Stainburn <gary.stainburn@xxxxxxxxxxxxxx> writes: > > ERROR: invalid multibyte character for locale > > HINT: The server's LC_CTYPE locale is probably incompatible with the > > database encoding. > > The HINT seems straightforward enough to me ;-). What do "show > lc_ctype" and "show server_encoding" say? > > regards, tom lane goole=# show lc_ctype; lc_ctype ------------- en_US.UTF-8 (1 row) goole=# show server_encoding; server_encoding ----------------- UNICODE (1 row) goole=# The documentation I read all related to installing and configuring the server. This has arisen from reading back into an existing server config a pg_dump that was taken from the same server. Gary -- Gary Stainburn This email does not contain private or confidential material as it may be snooped on by interested government parties for unknown and undisclosed purposes - Regulation of Investigatory Powers Act, 2000
