Gary Stainburn <gary.stainburn@ringways.co.uk> 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