Re: [BUGS] user names & non-ASCII

2012-01-09 Thread Robert Haas
On Fri, Dec 23, 2011 at 1:58 PM, Heikki Linnakangas wrote: > On 23.12.2011 19:21, Robert Haas wrote: >> >> On Thu, Dec 15, 2011 at 3:40 PM, Holec, JPH Software >>  wrote: >>> >>> I Have PostgreSQL server 8.4.9 on Linux, database utf-8 and Client app on >>> Windows (VC++ and libpq.dll). >>> I need

Re: [BUGS] user names & non-ASCII

2011-12-23 Thread Heikki Linnakangas
On 23.12.2011 19:21, Robert Haas wrote: On Thu, Dec 15, 2011 at 3:40 PM, Holec, JPH Software 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 PQconnectdb() with options="client_encoding=W

Re: [BUGS] user names & non-ASCII

2011-12-23 Thread Robert Haas
On Thu, Dec 15, 2011 at 3:40 PM, Holec, JPH Software 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 PQconnectdb() with > options="client_encoding=WIN1250" doesn't work. I think you

Re: [BUGS] user names & non-ASCII

2011-12-16 Thread Pavel Holec
User name with PQescapeBytea also doesn't help. 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

Re: [BUGS] user names & non-ASCII

2011-12-16 Thread Pavel Holec
anual 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 &

[BUGS] user names & non-ASCII

2011-12-15 Thread Holec, JPH Software
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

[BUGS] user names & non-ASCII

2011-12-15 Thread Holec, JPH Software
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

Re: [BUGS] user names & non-ASCII

2011-12-15 Thread Pavel Stehule
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, c

[BUGS] user names & non-ASCII

2011-12-15 Thread Pavel Holec
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