Skip site navigation (1) Skip section navigation (2)

Re: user names & non-ASCII

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Pavel Holec <holec(at)email(dot)cz>
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: user names & non-ASCII
Date: 2012-02-27 12:02:53
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-docs
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.

In response to

pgsql-docs by date

Next:From: Holec, JPH SoftwareDate: 2012-02-28 14:51:15
Subject: Invalid sequence for encoding UTF8 0xe86974
Previous:From: Magnus HaganderDate: 2012-02-15 09:56:59
Subject: Re: [DOCS] HTML Page titles in HTML version?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group