Re: Strange client encoding issue

Поиск
Список
Период
Сортировка
От Benjamin Krajmalnik
Тема Re: Strange client encoding issue
Дата
Msg-id F4E6A2751A2823418A21D4A160B689880E9253@fletch.stackdump.local
обсуждение исходный текст
Ответ на Re: Strange client encoding issue  ("Benjamin Krajmalnik" <kraj@illumen.com>)
Ответы Re: Strange client encoding issue  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Additional info:

Thanks to Tom Lane, who pointed me in the right direction concerning the
logging to identify the connection creating the problem.

The error is most definitely being generated by the ODBC connection.
What can be causing the ODBC driver to set the client encoding to Latin9
implicitly?


> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of
> Benjamin Krajmalnik
> Sent: Wednesday, January 16, 2008 3:45 PM
> To: Ivo Rossacher; pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Strange client encoding issue
>
> Ivo, thank you for responding.
> I know what the error message is saying.
> The database encoding is Latin1.
> I do not know where the Latin9 encoding is coming from, since
> I do not have anywhere any settings calling for a Latin9.
> The database is accessed both by a php script on box as well
> as a remote ODBC connection.
> From the frequency of the requests, I am inclined to believe
> tht it is the emote connection. Unlike 8.1, 8.2 is not
> tagging the log message with the IP address of the client
> connection, so I cannot even ascertain the source of the error :(
>
>
>
> > -----Original Message-----
> > From: pgsql-admin-owner@postgresql.org
> > [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Ivo Rossacher
> > Sent: Wednesday, January 16, 2008 3:32 PM
> > To: pgsql-admin@postgresql.org
> > Subject: Re: [ADMIN] Strange client encoding issue
> >
> > The encoding of the client can not be convertet to the
> encoding of the
> > server.
> > In the manual in chapter 21.2 you can find the list of supported
> > encodings and possible conversions between them.
> > The conversion between latin1 and latin9 is not supported.
> > For a latin9 database you can use the client encoding
> latin9 or utf8
> > but not latin1.
> >
> > Best regards
> > Ivo
> >
> > Am Mittwoch, 16. Januar 2008 21.30:42 schrieb Benjamin Krajmalnik:
> > > I am encountering a very strange client encoding issue.
> > > From the logs on the server, I am getting the following:
> > >
> > > canopy02# tail postgresql-2008-01-16_000000.log
> > > 2008-01-16 15:20:03 ESTERROR:  conversion between latin9
> > and LATIN1 is
> > > not supported
> > > 2008-01-16 15:20:03 ESTSTATEMENT:  set client_encoding to 'latin9'
> > > 2008-01-16 15:20:06 ESTLOG:  connection received:
> > host=192.168.111.25
> > > port=4236
> > > 2008-01-16 15:20:06 ESTLOG:  connection authorized: user=postgres
> > > database=ishield
> > > 2008-01-16 15:20:06 ESTERROR:  conversion between latin9
> > and LATIN1 is
> > > not supported
> > > 2008-01-16 15:20:06 ESTSTATEMENT:  set client_encoding to 'latin9'
> > > 2008-01-16 15:20:11 ESTLOG:  connection received:
> > host=192.168.111.25
> > > port=4253
> > > 2008-01-16 15:20:11 ESTLOG:  connection authorized: user=postgres
> > > database=ishield
> > > 2008-01-16 15:20:11 ESTERROR:  conversion between latin9
> > and LATIN1 is
> > > not supported
> > > 2008-01-16 15:20:11 ESTSTATEMENT:  set client_encoding to 'latin9'
> > >
> > > The application logging data is using the PostgreSQL ANSI
> > ODBC driver,
> > > version 08.01.02.00.
> > > Database server is PostgreSQL 8.2.5 on i386-portbld-freebsd6.2,
> > > compiled by GCC cc (GCC) 3.4.6 [FreeBSD] 20060305
> > >
> > > On page 2 of the datasources tab, in the Connect Settings
> > tab, I have
> > > the following:
> > >
> > > set client_encoding to 'latin1';
> > >
> > > to force the encoding.
> > > Any ideas on what may be creating this, and how to resolve it?
> >
> >
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 3: Have you checked our extensive FAQ?
> >
> >                http://www.postgresql.org/docs/faq
> >
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>

В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Arthurs
Дата:
Сообщение: Re: Backup of live database
Следующее
От: "Marc G. Fournier"
Дата:
Сообщение: Re: postgresql in FreeBSD jails: proposal