<?xml version="1.0" encoding="windows-1252"?>
<node id="700001" title="OT? Character set issues with MySQL/CGI::Application" created="2008-07-24 19:40:16" updated="2008-07-24 15:40:16">
<type id="115">
perlquestion</type>
<author id="61104">
cLive ;-)</author>
<data>
<field name="doctext">
&lt;p&gt;Or at least, that's my guess. I'm not sure what I should be looking for. The charset used by my table is latin1. I checked the http header of the generated html:&lt;/p&gt;
&lt;code&gt;Content-Type: text/html; charset=ISO-8859-1&lt;/code&gt;
&lt;p&gt;ie, latin1. Now, my biggest issue here is that I don't know what exactly the issue is that I'm meant to be examining.&lt;/p&gt;
&lt;p&gt;What changes a correct display of &lt;b&gt;Español&lt;/b&gt; in the DB and when testing in the shell to &lt;b&gt;EspaÃ±ol&lt;/b&gt; in the web page output.&lt;/p&gt;
&lt;p&gt;Anyone got any pointers?&lt;/p&gt;
&lt;p&gt;&lt;b&gt;update:&lt;/b&gt; When I call the test page using wget, the output displays correctly in vi, so I'm assuming that the issue is in what the browser thinks the output is. Hmmmmm.
&lt;p&gt;&lt;b&gt;update 2:&lt;/b&gt; changing the charset through header_props() to 'utf-8' presents the data correctly. So, I'm assuming that MySQL is throwing out the data as utf-8. Well, getting *some* progress here ;-)&lt;/p&gt;</field>
</data>
</node>
