Re: user names & non-ASCII - Mailing list pgsql-bugs

From Pavel Stehule
Subject Re: user names & non-ASCII
Date
Msg-id CAFj8pRBDHSV--_Wv6cG4gK8bAhXPHc2NQCfdxgTt9fyUsp_crw@mail.gmail.com
Whole thread Raw
In response to user names & non-ASCII  ("Pavel Holec" <holec@email.cz>)
Responses Re: user names & non-ASCII  ("Pavel Holec" <holec@email.cz>)
Re: user names & non-ASCII  ("Pavel Holec" <holec@email.cz>)
List pgsql-bugs
Hello

this is not bug

you can try use a system variable PGCLIENTENCODING

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

postgres=3D# 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 <holec@email.cz>:
> Hi All, please help.
>
> I Have PostgreSQL server 8.4.9 on Linux, database utf-8 and=C2=A0Client a=
pp on
> Windows (VC++ and libpq.dll).
> I need to use user account with non-ASCII and PQconnectdb()=C2=A0with
> options=3D"client_encoding=3DWIN1250" doesn't work.
> SET CLIENT_ENCODING TO 'WIN1250' after PQconnectdb is too late because
> connection fails.
>
> Best regards,
>
> Pavel Holec

pgsql-bugs by date:

Previous
From: "Pavel Holec"
Date:
Subject: user names & non-ASCII
Next
From: "Holec, JPH Software"
Date:
Subject: user names & non-ASCII