Re: user names & non-ASCII

Started by Peter Eisentrautabout 14 years ago1 messagesdocs
Jump to latest
#1Peter Eisentraut
peter_e@gmx.net

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.