I use MYSQL and I guess when I extract an attributes content, Cocoons ESQL converts german umlauts into escaped entities. I have this problem while generating a site keyword index.
I extract all keywords from my articles in the db, and then sort them alphabetically. But the Problem is that I don't get the Umlauts sorted correctly. What I mean is that the german O Umlaut which should be listed with the normal "O" words appears after "Z". Thats why I want to filter those special characters with an XSP and tell the following XSL to sort an umlaut O like "Oe". But that doesn't work. ----- Original Message ----- From: "Joerg Heinicke" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, November 17, 2002 1:49 AM Subject: Re: correct use of umlauts > Hello Robert, > > you are coding XML and not HTML. The German umlauts are only declared in > HTML as entities. In XML only <, >, ', " and &..; (which > one was the 5th) are known? > > Why do you have Ö in your database? This would be really bad: a > database should store a character in it, not an "entity, which will be > later interpreted as a character". > > Joerg > > Robert Sösemann wrote: > > Hello, who can help, > > > > > > I have the following code fragment in my xsp page, but I always get an error > > because of the use of german umlaut entities like Ö. > > > > <xsp:logic> > > String keyword = <esql:get-string > > column="k.word"/>; > > String firstletter = keyword.substring(0,6); > > String sortable = keyword; > > > > > > if( firstletter == "Ö" || > > firstletter == "ö" > > || firstletter == "Ä" || > > firstletter == "ä" > > || firstletter == "Ü" || > > firstletter == "ü") { > > firstletter = > > firstletter.substring(1,1).toUpperCase(); > > sortable = firstletter + "e" + > > keyword.substring(1); > > } > > </xsp:logic> > > > > That's how I get it from my database. How can I escape this? > > I also experience that cocoon has a problem to resolve &... entites in > > general. I allways get the error "The entity * was referenced, but not > > declared. > > > > What is wrong? > > > > Robert > > > --------------------------------------------------------------------- > 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]> > --------------------------------------------------------------------- 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]>