|
Home > Archive > PostgreSQL Discussion > April 2006 > using initcap() for the French charater
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
using initcap() for the French charater
|
|
| Emi Lu 2006-04-05, 9:30 am |
| 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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
| |
| Tom Lane 2006-04-05, 11:31 am |
| 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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
|
|
|
|
|