Re: Small problem with special characters

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Small problem with special characters
Date: 2006-08-24 17:47:10
Message-ID: eckomu$i5i$1@sea.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Tom Lane wrote on 24.08.2006 19:28:
> Thomas Kellerer <spam_eater(at)gmx(dot)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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message yazmin morales 2006-08-24 20:10:59 Cursor in JDBC
Previous Message Tom Lane 2006-08-24 17:28:14 Re: Small problem with special characters