Postgres Pro
Downloads
Home   >   mailing lists

Re: using initcap() for the French charater - Mailing list pgsql-general

From Tom Lane
Subject Re: using initcap() for the French charater
Date
Msg-id 423.1144249269@sss.pgh.pa.us
Whole thread Raw
In response to using initcap() for the French charater  (Emi Lu <emilu@encs.concordia.ca>)
List pgsql-general
Tree view 
Emi Lu <emilu@encs.concordia.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

pgsql-general by date:

Previous
From: Dick Wieland
Date:
Subject: [IDLE IN TRANSACTION] doing a remote pg_dump
Next
From: Stefan Nobis
Date:
Subject: Re: Oracle outer join syntax