PGCLIENTENCODING='latin2' - doesn't help (SetEnvironmentVariable) SET CLIENT_ENCODING TO - doesn't help (too late) connect with "only ascii" not possible (users are set) SET role TO specialcharsrole? google doesn't know On servers we have 8.4.7 not 9.1.1 In manual is PQconnectdb() with options="client_encoding =..." doesn't work
Pavel -----Original Message----- From: Pavel Stehule [mailto:pavel.steh...@gmail.com] Sent: Friday, December 16, 2011 12:18 AM To: Pavel Holec Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] user names & non-ASCII Hello 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 ; client_encoding ----------------- LATIN2 (1 row) other way is connect with "only ascii" user name, changing encoding and changin current role SET role TO specialcharsrole; Regards Pavel Stehule 2011/12/16 Pavel Holec <ho...@email.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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
