[Zope] rendering accented characters from postgres

Tue, 28 Aug 2001 13:39:17 +0100

<!doctype html public "-//W3C//DTD W3 HTML//EN">
<html><head><style type=3D"text/css"><!--
blockquote, dl, ul, ol, li { padding-top: 0 ; padding-bottom: 0 }
 --></style><title>rendering accented characters from
postgres</title></head><body>
<div>Hello,</div>
<div><br></div>
<div>I'm having problems rendering accented characters from Postgres.
A table with publication titles, mostly english, but also with welsh,
french and spanish titles does not render accented characters properly
in IE or Netscape. Using telnet on a Mac to access Postgres on Linux
with psql renders the titles correctly. The postgres table is Latin 1
encoded.</div>
<div><br></div>
<div>Telnet does not attempt any translation as far as I can tell but
can display the text correctly. IE has the default character set of
Western (Latin 1) but does not render the text correctly; instead of =E9
it displays<font face=3D"Verdana" color=3D"#000000"><i>
Z=9D</i></font>.</div>
<div><br></div>
<div>But, when I change the character set in IE to Western Mac the
characters display properly. Clients on Windows do not have this
character set.</div>
<div><br></div>
<div>Does anybody have any idea what I'm doing wrong or which is the
best way to do this?</div>
<div><br></div>
<div>Hwyl,</div>
<div><br></div>
<div>Sion</div>
<div>&nbsp;</div>
</body>
</html>