Skip site navigation (1) Skip section navigation (2)

Re: Strange client encoding issue

From: "Benjamin Krajmalnik" <kraj(at)illumen(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Strange client encoding issue
Date: 2008-01-17 05:16:50
Message-ID: F4E6A2751A2823418A21D4A160B689880E9253@fletch.stackdump.local (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-odbc
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(at)postgresql(dot)org 
> [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of 
> Benjamin Krajmalnik
> Sent: Wednesday, January 16, 2008 3:45 PM
> To: Ivo Rossacher; pgsql-admin(at)postgresql(dot)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(at)postgresql(dot)org 
> > [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Ivo Rossacher
> > Sent: Wednesday, January 16, 2008 3:32 PM
> > To: pgsql-admin(at)postgresql(dot)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
> 

In response to

Responses

pgsql-odbc by date

Next:From: Marc G. FournierDate: 2008-01-17 05:52:50
Subject: Re: postgresql in FreeBSD jails: proposal
Previous:From: Tom LaneDate: 2008-01-16 23:25:02
Subject: Re: Strange client encoding issue

pgsql-admin by date

Next:From: Marc G. FournierDate: 2008-01-17 05:52:50
Subject: Re: postgresql in FreeBSD jails: proposal
Previous:From: Tom ArthursDate: 2008-01-17 01:02:00
Subject: Re: Backup of live database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group