From: Peter Eisentraut <peter_e@gmx.net>
To: Pavel Holec <holec@email.cz>
Cc: pgsql-docs@postgresql.org
Subject: Re: user names & non-ASCII
Date: Mon, 27 Feb 2012 14:02:53 +0200
Message-ID: <1330344173.7111.23.camel@vanquo.pezone.net> (raw)
In-Reply-To: <!&!AAAAAAAAAAAYAAAAAAAAAE8q5Jcv4mJImRanr8cGRrPCgAAAEAAAAAv7tJgIvKxGhzVFyNnTLXMBAAAAAA==@email.cz>
References: <!&!AAAAAAAAAAAYAAAAAAAAAE8q5Jcv4mJImRanr8cGRrPCgAAAEAAAAAv7tJgIvKxGhzVFyNnTLXMBAAAAAA==@email.cz>
On tor, 2011-12-15 at 01:22 +0100, Pavel Holec wrote:
> I Have PostgreSQL server 8.4.9 on Linux, database utf-8 and Client app on Windows (VC++ and libpq.dll).
> I need to use user account with non-ASCII and that's my problem. SET CLIENT_ENCODING TO 'WIN1250' after PQconnectdb is too late because connection fails. I need set encoding with PQconnectdb() but options="client_encoding=WIN1250" doesn't work.
In the connection request, you effectively need to specify the user name
(and database name) as bytes in the encoding that you created them in.
I don't think this is documented in an obvious way.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: peter_e@gmx.net, holec@email.cz
Subject: Re: user names & non-ASCII
In-Reply-To: <1330344173.7111.23.camel@vanquo.pezone.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox