Re: Small problem with special characters

Tom Lane wrote on 24.08.2006 19:28:
> Thomas Kellerer <spam_eater@gmx.net> writes:
>> Hmm. Is there a way I can find out which encoding was specified with initdb?
>
> pg_controldata will show you the locale settings that initdb saw.  The
> encoding assigned to template0 is what initdb deduced it should use
> (unless you overrode it with the -E switch).

I only found a pg_settings, that contains the following:

server_encoding = UTF8
client_encoding = UNICODE

When I run createdb dbname this is created with UTF8, so it must have been
something stupid on my side. I don't think there is a problem with the installer.

Thanks for your help
Thomas