user names & non-ASCII
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
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 <holec@email.cz>:
Show quoted text
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
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.stehule@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 <holec@email.cz>:
Show quoted text
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
User name with PQescapeBytea also doesn't help. Pavel
-----Original Message-----
From: Pavel Stehule [mailto:pavel.stehule@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 <holec@email.cz>:
Show quoted text
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