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: 1330344173.7111.23.camel@vanquo.pezone.net (view raw or flat)
Thread:
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-2014 The PostgreSQL Global Development Group