You could use a template to exchange the Euro character in your database for the Unicode number. Here's one I use that works for escaping apostrophe's when for data I insert to MySQL databases. This template borrows heavily from one in Mike Kay's XSLT Reference 2nd ed. You could probably modify it for your particular requirement for multiple characters. Then you wouldn't have to change the data source.
<xsl:template name="TextOut"> <xsl:param name="text"/> <xsl:variable name="apos">'</xsl:variable> <xsl:variable name="ntext" select="$text"/> <xsl:choose> <xsl:when test="contains($text,$apos)"> <xsl:variable name="first" select="substring-before($ntext,$apos)"/> <xsl:variable name="rest-of-it" select="substring-after($ntext,$apos)"/> <xsl:value-of select="concat($first,'\',$apos)"/> <xsl:if test="$rest-of-it"> <xsl:call-template name="TextOut"><xsl:with-param name="text" select="$rest-of-it"/></xsl:call-template> </xsl:if> </xsl:when> <xsl:otherwise> <xsl:value-of select="$text"/> </xsl:otherwise> </xsl:choose> </xsl:template> hth, matthew l. avizinis -----Original Message----- From: Sergio Hernández [mailto:shernand@;ipsoluciones.com] Sent: Friday, October 25, 2002 11:20 AM To: [EMAIL PROTECTED] Subject: Re: problem with EURO symbol This is not the solution, because the data is stored in the database with the euro symbol, and I'm not going to search for all the DB to change this strange characters ... There's not any special tag that can escape this characters ? <[CDATA[€]] not runs ... Matthew L. Avizinis wrote: Use: € for the Euro and " for the " (you can use “and ” if you want left and right double quotes) Matthew L. Avizinis <mailto:mla@;gleim.com>Gleim Publications, Inc. 4201 NW 95th Blvd. Gainesville, FL 32606(352)-375-0772 www.gleim.com <http://www.gleim.com> -----Original Message-----From: Sergio Hernández [mailto:shernand@;ipsoluciones.com]Sent: Friday, October 25, 2002 9:44 AMTo: [EMAIL PROTECTED]: problem with EURO symbolHí, sorry for my English.I'm rendering from XSLFO (using data from SqlServer database) to PDFdinamicaly.The problem is that some characters, like EUR (Euro), or " , are intothe DataBase, are not seen correctly. At the position of this charactersare replaced by ? or # symbol.Can anyone help me?Thanks,Sergio.----------------------------------------------------------- ----------To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED] ---------------------------------------------------------------------To unsubscribe, e-mail: [EMAIL PROTECTED] additional commands, email: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]