>1) Did you compile PostgreSQL with --enable-locale Yes.
>2) Did you set correct locale for postmaster (LANG=xxx) Database was create using CREATE db WITH ENCODING='UNICODE'. pgsql: \encoding returns UNICODE. The db stores multiple languages (French, English, Japanese). Why should I define a *single* locale for postmaster? Do I miss something? Best regards, Jean-Michel POURE ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly