[Dhruva]

HI all ,

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.

Application is capturing the data in the tinymce editor field, data is saved in db as below


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 : , " > < ? / | \


But displayed as below

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 : , &quot; &gt; &lt; ? / | \



The above are the examples only , there might be a lot of it.

The data might contain Special characters German, Japanese language etc... we wanted to display all these language data in the report.

Kindly help ASAP.

Thanks in advance.

[cbrell]

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.

[Dhruva]

Dear friend ,

Thanks a bunch
" 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."

The above reply of your's helped me . I was able to solve the issue

cbrell, on 24 April 2012 - 03:31 AM, said:

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.