Re: DB and Unicode problem (was: user and DB confusion) - Mailing list pgsql-general

From Tino Wildenhain
Subject Re: DB and Unicode problem (was: user and DB confusion)
Date
Msg-id 48F333D4.3050801@wildenhain.de
Whole thread Raw
In response to DB and Unicode problem (was: user and DB confusion)  ("arnuld uttre" <arnuld.mizong@gmail.com>)
Responses Re: DB and Unicode problem (was: user and DB confusion)  ("arnuld uttre" <arnuld.mizong@gmail.com>)
List pgsql-general
arnuld uttre wrote:
...
> and I phpBB can connect to the DB now but with a new problem from
> phoBB3:    The database you have selected was not created in UNICODE
> or UTF8 encoding. Try installing with a database in UNICODE or UTF8
> encoding.
>
>
> what to do about it ?

Well exactly that. What information is missing?

There is a parameter on createdb command line
(As well as CREATEDB command in SQL) which
needs to be set to unicode.

Hint: to get collation right, you might want to
initdb first (with empty $PGDATA) with correct
locale settings (including charset UTF-8 which will
then be the default encoding for all subsequent
created databases.

HTH
Tino

Attachment

pgsql-general by date:

Previous
From: "arnuld uttre"
Date:
Subject: DB and Unicode problem (was: user and DB confusion)
Next
From: Ivan Sergio Borgonovo
Date:
Subject: multi recordset and data type check was: Re: PL/pgSQL stored procedure returning multiple result sets (SELECTs)?