Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 23E1F2E159F for ; Wed, 16 Jan 2008 18:32:26 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 88903-01 for ; Wed, 16 Jan 2008 18:32:16 -0400 (AST) Received: from mail17.bluewin.ch (mail17.bluewin.ch [195.186.18.64]) by postgresql.org (Postfix) with ESMTP id 69BF72E2D80 for ; Wed, 16 Jan 2008 18:32:20 -0400 (AST) Received: from [192.168.1.74] (85.1.199.70) by mail17.bluewin.ch (Bluewin 7.3.121) id 476BDE98005CEB05 for pgsql-admin@postgresql.org; Wed, 16 Jan 2008 22:32:17 +0000 From: Ivo Rossacher To: pgsql-admin@postgresql.org Subject: Re: Strange client encoding issue Date: Wed, 16 Jan 2008 23:32:17 +0100 User-Agent: KMail/1.9.6 (enterprise 20070904.708012) References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="windows-1252" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200801162332.17449.rossacher@bluewin.ch> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/190 X-Sequence-Number: 27964 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?