Re: DB and Unicode problem (was: user and DB confusion)

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