Unicode Support BIRT

Dhruva

HI all , <br />
<br />
I have a major problem with special charters and HTML characters in the report which i designed. Kindly help me as this is very critical to us. <br />
<br />
Application is capturing the data in the tinymce editor field, data is saved in db as below<br />
<br />
<br />
This is a editor column to check if the special characters are displayed or not .. Exclmation = ! , at the rate = @ , hash = # , dollar $ , percentage = % , superscript ^ , and = & , asterik = * , smal bracket open = ( , small bracket closee = ) , flower bracket = { } , semi colon : , " > < ? / | \<br />
<br />
<br />
But displayed as below <br />
<br />
This is a editor column to check if the special characters are displayed or not .. Exclmation = ! , at the rate = @ , hash = # , dollar $ , percentage = % , superscript ^ , and = &amp; , asterik = * , smal bracket open = &nbsp;( , small bracket closee = ) , flower bracket = { } , semi colon : , <strong class='bbc'>&quot; &gt; &lt; ? /</strong> | \<br />
<br />
<br />
<br />
The above are the examples only , there might be a lot of it.<br />
<br />
The data might contain Special characters German, Japanese language etc... we wanted to display all these language data in the report. <br />
<br />
Kindly help ASAP. <br />
<br />
Thanks in advance.

CBR

Hi,

this issue doesn't seem to be unicode related. As far as i know Tinymce replaces all special characters with the corresponding HTML entities. I m assuming that the data is already saved as html in your database.

BIRT is assuming that all data in database is as is. Which means it prints out the text in the same way as it is in the database (so html encoding happens twice).

You have two different solutions:
- configure tinymce to not replace special characters with the corresponding HTML entity
- use dynamic text elements to print out corresponding text columns: The dynamic text element is assuming that the text is html and doesn't encode the text.