using initcap() for the French charater

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: using initcap() for the French charater
Date: 2006-04-05 14:26:02
Message-ID: 4433D37A.8030809@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I am having a problem of using initcap() for the French charater.

. create table test (id varchar(3));
. insert into test values('É');
. select initcap(id) from test;

*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".

Ying

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GUNDUZ 2006-04-05 14:35:08 Re: 8.1.3's /etc/init.d/postgresql fails, logging
Previous Message Tom Lane 2006-04-05 14:03:06 Re: pg_dump and copy command