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

Re: user names & non-ASCII

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Pavel Holec <holec(at)email(dot)cz>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: user names & non-ASCII
Date: 2011-12-15 23:17:42
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs

this is not bug

you can try use a system variable PGCLIENTENCODING

bash-4.2$ PGCLIENTENCODING='latin2' psql postgres
psql (9.1.1)
Type "help" for help.

postgres=# show client_encoding ;
(1 row)

other way is connect with "only ascii" user name, changing encoding
and changin current role

SET role TO specialcharsrole;


Pavel Stehule

2011/12/16 Pavel Holec <holec(at)email(dot)cz>:
> Hi All, please help.
> 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 PQconnectdb() with
> options="client_encoding=WIN1250" doesn't work.
> SET CLIENT_ENCODING TO 'WIN1250' after PQconnectdb is too late because
> connection fails.
> Best regards,
> Pavel Holec

In response to


pgsql-bugs by date

Next:From: andreagrassiDate: 2011-12-16 07:45:42
Subject: BUG #6342: libpq blocks forever in "poll" function
Previous:From: Pavel HolecDate: 2011-12-15 23:06:53
Subject: user names & non-ASCII

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