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

From arnuld uttre
Subject Re: DB and Unicode problem (was: user and DB confusion)
Date
Msg-id 3a97b5b90810130503h3547273fjaf5a14b216fcfa60@mail.gmail.com
Whole thread Raw
In response to Re: DB and Unicode problem (was: user and DB confusion)  (Tino Wildenhain <tino@wildenhain.de>)
List pgsql-general
> On Mon, Oct 13, 2008 at 5:11 PM, Tino Wildenhain <tino@wildenhain.de> wrote:
> 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.

yes my friend :)   -E utf8

thanks


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

default is ISO-8859. I can't make it to UTF8 because then my VLC stops
working :\ . Quite very unusual problem.



--
http://uttre.wordpress.com/2008/05/14/the-lost-love-of-mine/

pgsql-general by date:

Previous
From: Ivan Sergio Borgonovo
Date:
Subject: multi recordset and data type check was: Re: PL/pgSQL stored procedure returning multiple result sets (SELECTs)?
Next
From: Vladimir Dzhuvinov
Date:
Subject: Re: PL/pgSQL stored procedure returning multiple result sets (SELECTs)?