This is a multi-part message in MIME format.
------_=_NextPart_001_01C8587E.AA4FED97
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
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=3D192.168.111.25
port=3D4236
2008-01-16 15:20:06 ESTLOG: connection authorized: user=3Dpostgres
database=3Dishield
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=3D192.168.111.25
port=3D4253
2008-01-16 15:20:11 ESTLOG: connection authorized: user=3Dpostgres
database=3Dishield
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?
------_=_NextPart_001_01C8587E.AA4FED97
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2900.3243" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D412432320-16012008><FONT face=3DArial size=3D2>I am =
encountering a
very strange client encoding issue.</FONT></SPAN></DIV>
<DIV><SPAN class=3D412432320-16012008><FONT face=3DArial size=3D2>From =
the logs on the
server, I am getting the following:</FONT></SPAN></DIV>
<DIV><SPAN class=3D412432320-16012008><FONT face=3DArial
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D412432320-16012008><FONT face=3DArial =
size=3D2>canopy02# tail
postgresql-2008-01-16_000000.log<BR>2008-01-16 15:20:03 ESTERROR:
conversion between latin9 and LATIN1 is not supported<BR>2008-01-16 =
15:20:03
ESTSTATEMENT: set client_encoding to 'latin9'<BR>2008-01-16 =
15:20:06
ESTLOG: connection received: host=3D192.168.111.25 =
port=3D4236<BR>2008-01-16
15:20:06 ESTLOG: connection authorized: user=3Dpostgres
database=3Dishield<BR>2008-01-16 15:20:06 ESTERROR: conversion =
between
latin9 and LATIN1 is not supported<BR>2008-01-16 15:20:06 =
ESTSTATEMENT:
set client_encoding to 'latin9'<BR>2008-01-16 15:20:11 ESTLOG: =
connection
received: host=3D192.168.111.25 port=3D4253<BR>2008-01-16 15:20:11 =
ESTLOG:
connection authorized: user=3Dpostgres database=3Dishield<BR>2008-01-16 =
15:20:11
ESTERROR: conversion between latin9 and LATIN1 is not
supported<BR>2008-01-16 15:20:11 ESTSTATEMENT: set client_encoding =
to
'latin9'<BR></FONT></SPAN></DIV>
<DIV><SPAN class=3D412432320-16012008><FONT face=3DArial size=3D2>The =
application
logging data is using the PostgreSQL ANSI ODBC driver, version
08.01.02.00.</FONT></SPAN></DIV>
<DIV><SPAN class=3D412432320-16012008><FONT face=3DArial =
size=3D2>Database server
is PostgreSQL 8.2.5 on i386-portbld-freebsd6.2, compiled by GCC cc =
(GCC)
3.4.6 [FreeBSD] 20060305</FONT></SPAN></DIV>
<DIV><SPAN class=3D412432320-16012008><FONT face=3DArial
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D412432320-16012008><FONT face=3DArial size=3D2>On =
page 2 of the
datasources tab, in the Connect Settings tab, I have the
following:</FONT></SPAN></DIV>
<DIV><SPAN class=3D412432320-16012008><FONT face=3DArial
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D412432320-16012008><FONT face=3DArial size=3D2>set =
client_encoding
to 'latin1';</FONT></SPAN></DIV>
<DIV><SPAN class=3D412432320-16012008><FONT face=3DArial
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D412432320-16012008><FONT face=3DArial size=3D2>to =
force the
encoding.</FONT></SPAN></DIV>
<DIV><SPAN class=3D412432320-16012008><FONT face=3DArial size=3D2>Any =
ideas on what
may be creating this, and how to resolve it?</FONT></SPAN></DIV>
<DIV><SPAN class=3D412432320-16012008></SPAN> </DIV>
<DIV><SPAN class=3D412432320-16012008><FONT face=3DArial
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D412432320-16012008><FONT face=3DArial
size=3D2> </DIV></FONT></SPAN></BODY></HTML>
------_=_NextPart_001_01C8587E.AA4FED97--
