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@xxxxxxxxxxxxxx > [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Ivo Rossacher > Sent: Wednesday, January 16, 2008 3:32 PM > To: pgsql-admin@xxxxxxxxxxxxxx > Subject: Re: 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
