You are viewing a plain text version of this content. The canonical link for it is here.
Posted to general@xml.apache.org by Manfred Tremmel <Ma...@iiv.de> on 2000/06/06 21:32:01 UTC

Problems with german umlauts and sql

Hello from germany,

first of all I'll beg your pardon, my english is not
good, I hopy you can understand, what I want to say.

Since last Thursday I've updated cocoon 1.5, because of
some problems generating PDF-Documents, I've updated to
1.7.4 and now I've two big problmes.

1. Using german umlauts dosn't work anymore, using
   only only one ö (little o with two dots on the top
   &ouml; in HTML) in a big cocument, crashes cocoon:

------------------ beginn error message ---------------------
org.xml.sax.SAXParseException: An invalid XML character (Unicode: 0x1ae289) was found in the element content of the document.
              at org.apache.cocoon.parser.AbstractParser.fatalError(AbstractParser.java:105)
              at org.apache.xerces.framework.XMLParser.reportError(XMLParser.java:954)
              at org.apache.xerces.framework.XMLDocumentScanner.reportFatalXMLError(XMLDocumentScanner.java:643)
              at org.apache.xerces.framework.XMLDocumentScanner$ContentDispatcher.dispatch(XMLDocumentScanner.java:1355)
              at org.apache.xerces.framework.XMLDocumentScanner.parseSome(XMLDocumentScanner.java:380)
              at org.apache.xerces.framework.XMLParser.parse(XMLParser.java:817)
              at org.apache.cocoon.parser.XercesParser.parse(XercesParser.java:84)
              at org.apache.cocoon.parser.AbstractParser.parse(AbstractParser.java:83)
              at org.apache.cocoon.producer.ProducerFromFile.getDocument(ProducerFromFile.java:78)
              at org.apache.cocoon.Engine.handle(Engine.java:289)
              at org.apache.cocoon.Cocoon.service(Cocoon.java:167)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
              at org.apache.jserv.JServConnection.processRequest(JServConnection.java:317)
              at org.apache.jserv.JServConnection.run(JServConnection.java:188)
              at java.lang.Thread.run(Thread.java:475)
------------------  end error message ---------------------
   Using decimal equivalent &#246; works in statik sites,
   using in a dcp java-class the &#246; this is displayed 
   unchanged in my Browser, not the wanted umlaut...

2. sql statements with < and/or > don't work anymore, the following
   statement
   SELECT CONCAT("/servlet/KnightSoftGewinnspielWorldServlet?dbnummer=", zaehler) as LINK, CONCAT("Gewinnspiel ", zaehler) as LINKNAME FROM KnightSoft_Gewinnspiel WHERE eintrag_gesperrt='N' AND system='GewinnspielWorld' AND datum_von<=CURDATE() AND datum_bis>=CURDATE()
   causes
------------------ beginn error message ---------------------
org.xml.sax.SAXParseException: The content of elements must consist of well-formed character data or markup.
              at org.apache.cocoon.parser.AbstractParser.fatalError(AbstractParser.java:105)
              at org.apache.xerces.framework.XMLParser.reportError(XMLParser.java:954)
              at org.apache.xerces.framework.XMLDocumentScanner.reportFatalXMLError(XMLDocumentScanner.java:625)
              at org.apache.xerces.framework.XMLDocumentScanner.abortMarkup(XMLDocumentScanner.java:679)
              at org.apache.xerces.framework.XMLDocumentScanner$ContentDispatcher.dispatch(XMLDocumentScanner.java:1245)
              at org.apache.xerces.framework.XMLDocumentScanner.parseSome(XMLDocumentScanner.java:380)
              at org.apache.xerces.framework.XMLParser.parse(XMLParser.java:817)
              at org.apache.cocoon.parser.XercesParser.parse(XercesParser.java:84)
              at org.apache.cocoon.parser.AbstractParser.parse(AbstractParser.java:83)
              at org.apache.cocoon.producer.ProducerFromFile.getDocument(ProducerFromFile.java:78)
              at org.apache.cocoon.Engine.handle(Engine.java:289)
              at org.apache.cocoon.Cocoon.service(Cocoon.java:167)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
              at org.apache.jserv.JServConnection.processRequest(JServConnection.java:317)
              at org.apache.jserv.JServConnection.run(JServConnection.java:188)
              at java.lang.Thread.run(Thread.java:475)
------------------  end error message ---------------------
   I've solved it using a between ...

Today I've updatet xerces to 1.1.1, nothing changed. Can anybody
tell me, what to do?

PS: Using SuSE Linux 6.3 (Kernel updated to 2.2.15), Apache 1.3.9,
    JServ 1.1.1-1, JDK 1.2.2 (Sun), JSDK 2.0 (jar file out of the
    solaris version) Cocoon 1.7.4 with (today) updated xerces to
    1.1.1.

cu

Manfred Tremmel

Re: Problems with german umlauts and sql

Posted by Manfred Tremmel <Ma...@iiv.de>.
Hello,

> 1. Using german umlauts dosn't work anymore, using
>    only only one ö (little o with two dots on the top
>    &ouml; in HTML) in a big cocument, crashes cocoon:

my foult, I've set the wrong encoding, sorry.

-- 
cu               | http://www.iiv.de/schwinde/buerger/tremmel/
                 | http://www.knightsoft.de
Manfred          | http://www.knightsoft-net.de