Emi Lu <emilu(at)encs(dot)concordia(dot)ca> writes:
> *Got ERROR:* invalid multibyte character for locale
> HINT: The server's LC_CTYPE locale is probably incompatible with the
> database encoding.
> By the way, both my client and server encoding are "UNICODE".
Sounds like you initdb'd using a locale that expects some other encoding
than UTF8.
regards, tom lane