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">&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:  &#x20AC; for the Euro   and  &#x0022; for the "  (you can use
&#x201C;and &#x201D; 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]

Reply via email to