Hi Guys,
If I use enocding="UTF-8" I get en error "An invalid character was found in text content..." where as if I use enocding="ISO-8859-1" or "ISO-8859-15" xml displays without en error but with white space. It doesn't show me Euro symbol. So I would like to know which encoding I should use to handle this issue?
I have xml file content like below.
<?xml version="1.0" encoding="ISO-8859-1"?>
<?xml-stylesheet type="text/xsl" href="TrxLs1.xsl"?>
<Dataroot xmlns:od="urn:schemas-micr
osoft-com:
officedata
">
<ROW>
<TRX_NO>010895</TRX_NO>
<TRXDATE>3/6/2006</TRXDATE
>
<TRX_TYPE>CD</TRX_TYPE>
<CHECK_NUM>1</CHECK_NUM>
<ENTDAT>3/7/2006</ENTDAT>
<ENTTIME>10:51:39</ENTTIME
>
<USER_ID>KOO</USER_ID>
<AMT_CR>17413.86</AMT_CR>
<AMT_DR>0</AMT_DR>
<AMOUNT>-114578.72</AMOUNT
>
<TRAILER>PWC AUDIT FEE FOR THE PERIOD
ENDING OCT 31, 2005 - 14,500
</TRAILER>
<PFTRX_NO> </PFTRX_NO
>
<BAS_M_DECS>2</BAS_M_DECS>
<BAS_Q_DECS>4</BAS_Q_DECS>
<GL_ACNO>1-120-00000-00000
</GL_ACNO>
<GL_DESC1>CASH</GL_DESC1>
<GL_DESC2> </GL_DESC2
>
<MANUAL>Y</MANUAL>
<FUNDNAME>GLOBAL COMMODITY MARKETS FUND 2 LTD</FUNDNAME>
<FUND>GCMF2</FUND>
<DBNAME>DATA9</DBNAME>
<STARTDATE>11/1/2005</STAR
TDATE>
<ENDDATE>4/30/2006</ENDDAT
E>
<OPNBAL>0</OPNBAL>
<DRCRFLG>C</DRCRFLG>
<BALANCEFLG>0</BALANCEFLG>
</ROW>
</Dataroot>
TRXLS1.XSL content:
<?xml version="1.0" ?>
<xsl:stylesheet xmlns:xsl="
http://www.w3.org/TR/WD-xsl">
<xsl:template match="/">
<CENTER>
<DIV>
<TABLE BORDER="1" BGCOLOR="#ffffff" CELLSPACING="1" CELLPADDING="1">
<TR>
<TH style="width: 1.9375in">
TRX_NO
</TH>
<TH style="width: 1.9375in">
TRXDATE
</TH>
<TH style="width: 1.9375in">
TRX_TYPE
</TH>
<TH style="width: 1.9375in">
CHECK_NUM
</TH>
<TH style="width: 1.9375in">
ENTDAT
</TH>
<TH style="width: 1.9375in">
ENTTIME
</TH>
<TH style="width: 1.9375in">
USER_ID
</TH>
<TH style="width: 1.9375in">
AMT_CR
</TH>
<TH style="width: 1.9375in">
AMT_DR
</TH>
<TH style="width: 1.9375in">
AMOUNT
</TH>
<TH style="width: 1.9375in">
TRAILER
</TH>
<TH style="width: 1.9375in">
PFTRX_NO
</TH>
<TH style="width: 1.9375in">
BAS_M_DECS
</TH>
<TH style="width: 1.9375in">
BAS_Q_DECS
</TH>
<TH style="width: 1.9375in">
GL_ACNO
</TH>
<TH style="width: 1.9375in">
GL_DESC1
</TH>
<TH style="width: 1.9375in">
GL_DESC2
</TH>
<TH style="width: 1.9375in">
MANUAL
</TH>
<TH style="width: 1.9375in">
FUNDNAME
</TH>
<TH style="width: 1.9375in">
FUND
</TH>
<TH style="width: 1.9375in">
DBNAME
</TH>
<TH style="width: 1.9375in">
STARTDATE
</TH>
<TH style="width: 1.9375in">
ENDDATE
</TH>
<TH style="width: 1.9375in">
OPNBAL
</TH>
<TH style="width: 1.9375in">
DRCRFLG
</TH>
<TH style="width: 1.9375in">
BALANCEFLG
</TH>
</TR>
<xsl:for-each select="/Dataroot/ROW">
<TR>
<TD>
<xsl:value-of select="TRX_NO"/>
</TD>
<TD>
<xsl:value-of select="TRXDATE"/>
</TD>
<TD>
<xsl:value-of select="TRX_TYPE"/>
</TD>
<TD>
<xsl:value-of select="CHECK_NUM"/>
</TD>
<TD>
<xsl:value-of select="ENTDAT"/>
</TD>
<TD>
<xsl:value-of select="ENTTIME"/>
</TD>
<TD>
<xsl:value-of select="USER_ID"/>
</TD>
<TD>
<xsl:value-of select="AMT_CR"/>
</TD>
<TD>
<xsl:value-of select="AMT_DR"/>
</TD>
<TD>
<xsl:value-of select="AMOUNT"/>
</TD>
<TD>
<xsl:value-of select="TRAILER"/>
</TD>
<TD>
<xsl:value-of select="PFTRX_NO"/>
</TD>
<TD>
<xsl:value-of select="BAS_M_DECS"/>
</TD>
<TD>
<xsl:value-of select="BAS_Q_DECS"/>
</TD>
<TD>
<xsl:value-of select="GL_ACNO"/>
</TD>
<TD>
<xsl:value-of select="GL_DESC1"/>
</TD>
<TD>
<xsl:value-of select="GL_DESC2"/>
</TD>
<TD>
<xsl:value-of select="MANUAL"/>
</TD>
<TD>
<xsl:value-of select="FUNDNAME"/>
</TD>
<TD>
<xsl:value-of select="FUND"/>
</TD>
<TD>
<xsl:value-of select="DBNAME"/>
</TD>
<TD>
<xsl:value-of select="STARTDATE"/>
</TD>
<TD>
<xsl:value-of select="ENDDATE"/>
</TD>
<TD>
<xsl:value-of select="OPNBAL"/>
</TD>
<TD>
<xsl:value-of select="DRCRFLG"/>
</TD>
<TD>
<xsl:value-of select="BALANCEFLG"/>
</TD>
</TR>
</xsl:for-each>
</TABLE>
</DIV>
</CENTER>
</xsl:template>
</xsl:stylesheet>
Thanks in advance,
Kiran Mahale
Start Free Trial
