Hi I have a PostgreSQL Database. Data is stored with SQL Transformer into the
database. But when I make a select on that table, I see strange symbols
instead of the �, �, � or �.
Is there something wrong with the character settings or localization in cocoon?
I have cocoon 2.1.2, tomcat 4.1.29, mod_jk2, apache 2.0.48, Postgresql 7.4. The Database was initdb - lized with de_CH.ISO8859-1, I have also tried
de_CH. (I'm from Switzerland).
The error localization is not very exact. Nearly everything is possible at the moment: the SQLTransformer gets already corrupted characters, the SQLTransformer itself breaks them, the database has a wrong encoding, the select happens with a wrong encoding, and at the end it can be possible that the output encoding is not correct. You see you must localize the error, the best thing for doing this is probably remote debugging. MySQL offers a profileSql=true as additional parameter to the database URL, maybe PostgreSQL provides something similar. Tomcat 4.1.29 can be a problem (http://issues.apache.org/bugzilla/show_bug.cgi?id=26997), but should not if you have everything in ISO-8859-1 as this charset is the default.
Joerg
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
