Koen Pellegrims wrote: >I don't know about Postgres, but with MySQL, you can set a parameter on the >jdbc-driver in web.xml >eg.: > ><jdbc name="mydb"> > <encoding>ISO-8859-15</encoding> >
It'd better be UTF-8. Whole XML world lives in UTF-8, and Java characters know nothing except UTF-8 (101 of Java char type). Thus, when your database returns non-UTF, of course you can do some tricks to make result look Ok, but this does not solve the issue. Point here is when your database, say, in ISO-8859-15, and you want output HTML in same encoding, then it will work. But if you ask serializer to use other encoding (which it can do - if input is valid), result will be garbage, because serializer when encoding will *assume* that input is UTF-8 - but it is not. Regards, Vadim > <dburl>jdbc:mysql://<server>/<db> ></jdbc> > > > >>-----Oorspronkelijk bericht----- >>Van: Antonio Gallardo Rivera [mailto:[EMAIL PROTECTED]] >>Verzonden: donderdag 29 augustus 2002 10:45 >>Aan: [EMAIL PROTECTED] >>Onderwerp: Re: How to encode ISO-8859-1 characters into the Database? >> >> >>I create the Database now using the following string: >> >>createdb -E LATIN1 -e mydb >> >>Where, >>LATIN1 is the encoding used by the database >>mydb is the name of the database >> >>Now When I wrote: "Olé" >>When I retrieve the values there are: "Olé" >> >>Please, somebody know how to resolve this problem. I used at the >>beginning of >>the XSP pages the string: >> >><?xml version="1.0" encoding="ISO-8859-1"?> >> >>What I am doing wrong? >> >>Regards, >> >>Antonio Gallardo >> >> >> ... --------------------------------------------------------------------- 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]>
