SORRY I'VE POSTED THIS YET BUT I FORGOT THE SUBJECT
I'm using ESQL to read and write data from a MYSQL database.
When I fill a field with non US characters, I see strange characters instead of the
ones I expected.
For example, when I write the string "���", this is written like "=a?", even if when I
red it with ESQL I get back the right string.
if I manually try from mysql prompt:
"INSERT INTO table VALUES ('���')", the data is properly stored.
I've read an article at
http://marc.theaimsgroup.com/?l=xml-cocoon-users&m=103701015026425&w=2
about a similar subject, but the author speak of a request generator and an XML
serializer, while I'm using an xsp generator and an html serializer:
<map:match pattern="*/*.html">
<map:generate type="serverpages" src="{1}/{2}.xsp"/>
<map:transform src="{1}/{2}.xsl"/>
<map:serialize type="html"/>
</map:match>
They suggest to use the SetCharacterEncodingAction, but it hasn't solved my problem.
MySQL uses the default ISO-8859-1 encoding and I've added the ISO-8859-1 encoding to
the html serializer:
<map:serializer logger="sitemap.serializer.html" mime-type="text/html" ...>
<encoding>ISO-8859-1</encoding>
<buffer-size>1024</buffer-size>
</map:serializer>
I've tried to add the same encoding element to the serverpages generator, but it
didn't work.
Any suggestion?
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
