Re: encoding of PostgreSQL messages

From: John DeSoi <desoi(at)pgedit(dot)com>
To: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: encoding of PostgreSQL messages
Date: 2008-12-24 04:10:28
Message-ID: 642262EA-CE75-48E0-8574-7BEADDAC5766@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Dec 23, 2008, at 4:24 PM, Karsten Hilbert wrote:

> How can I programmatically detect which encoding a
> PostgreSQL server I am trying to connect to sends back
> messages -- before I connect (so client_encoding and
> the pg_settings table are flat out).

I don't think there is a way because you can't get any information
without authorizing first.

It is also unclear to me how things work in the other direction. When
authenticating, what if the user or database name have non-ascii
characters. Are they interpreted in the encoding of the server since
the client has not established an encoding?

John DeSoi, Ph.D.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message justin 2008-12-24 04:56:26 Re: need some help with pl-pgsql
Previous Message Adrian Klaver 2008-12-24 03:45:57 Re: need some help with pl-pgsql