Fetching Greek Characters from DB And Display

2005 IR Help · August 26, 2006

By: Ramesh - ramesh_t

2004-07-29 05:44

Hi,

I am Using ireport for designing report templet . There are some db fields which will contain greek character. I have to display those text in output screen. Now I am saving the report as a HTML file.

But when we are opening the HTML file it is isplaying junk.

Please give me some idea how can I implement this.

Thanks in advance for yours help.

Here is code used for testing:-

JasperDesign jasperDesign = JasperManager.loadXmlDesign("CitiReceipt2.xml");

JasperReport jasperReport = JasperManager.compileReport(jasperDesign);

// Second, create a map of parameters to pass to the report.

Map parameters = new HashMap();

parameters.put("SYSTEM_DATE", "Naiaoc");

// Third, get a database connection

Connection conn = Test.getConnection();

// Fourth, create JasperPrint using fillReport() method

JasperPrint jasperPrint = JasperManager.fillReport(jasperReport,

parameters, conn);

JRHtmlExporter exporter = new JRHtmlExporter ();

StringBuffer Buffer = new StringBuffer();

exporter.setParameter(JRExporterParameter.JASPER_PRINT,jasperPrint);

exporter.setParameter(JRExporterParameter.OUTPUT_STRING_BUFFER,Buffer);

exporter.exportReport();

System.out.println("Before Hello World!");

System.out.println(Buffer.toString());

JasperExportManager.exportReportToHtmlFile(jasperPrint,"CitiReceipt.html") ;

Thanks

Ramesh

By: Mykel Alvis - evilarchitect

RE: Fetching Greek Characters from DB And Display

2004-07-29 07:22

For my idle curiosity, what does

"parameters.put("SYSTEM_DATE", "Naiaoc");"

do?

Can you post a segment of the generated HTML? Just a few lines containing the result.

Are you sure the database is storing the data correctly (like difference between a VARCHAR and an NVARCHAR in SQL Server)?

Are you sure your browser has the appropriate language capability?

Have you tried viewing the report exported to a PDF or in the applet viewer?

By: Ramesh - ramesh_t

RE: Fetching Greek Characters from DB And Display

2004-07-29 19:25

SYSTEM_DATE is java.lang.String type.

"parameters.put("SYSTEM_DATE", "Naiaoc");"

This statement we did for testing only.

Curently we are displaying same greek data from webpages. But when we are displaying from report

it is showing junk.

The sample Html File:-

<html>

<head>

a {text-decoration: none}

</style>

</head>

<table width=595 cellpadding=0 cellspacing=0 border=0

bgcolor=white>

<tr>

</tr>

</tr>

<td colspan=25 valign="middle" style="background-color: #CC00CC; text-align: center;">Citi Receipt</td>

</tr>

</tr>

</tr>

</tr>

</tr>

</tr>

</tr>

</tr>

</tr>

</tr>

</tr>

</tr>

</tr>

</tr>

</tr>

</tr>

</tr>

</tr>

</tr>

</tr>

</tr>

</tr>

</tr>

</tr>

</tr>

</tr>

</table>

</td><td width="50%"> </td></tr>

</table>

</body>

</html>

By: Mykel Alvis - evilarchitect

RE: Fetching Greek Characters from DB And Dis

2004-07-29 20:22

OK. You've definitely got some issues.

Problem number one: You've got a lot of lines on the page. This isn't serious, but I was never able to get this to look good.

Problem number two: This is the killer.

Your character encoding is UTF-8. That's ascii. That's a big no-no for doing foreign other languages.

You need to figure out how to set the html character encoding to something that supports your character set so that the headers get generated correctly. I don't know what that is, since I don't really do anything with i18n directly.

Good luck. Post your solution.

By: Paulo Soares - psoares33

RE: Fetching Greek Characters from DB And Dis

2004-07-30 03:25

UTF-8 supports all the Unicode characters. That's not the problem. Some generic considerations:

- the data stored in the DB may be stored as bytes that have to be converted to a String using some encoding

- the DB driver gives you a String but there's a mismatch between the DB encoding and what's actually stored

- you must have an html encoding compatible with what you put there. This may or may not be a JR problem

By: Ramesh - ramesh_t

RE: Fetching Greek Characters from DB And Display

2004-07-29 23:24

I have tried with carset="iso-8859-7" but still it is same.

Sign In

Fetching Greek Characters from DB And Display

Recommended Posts

2005 IR Help

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

Create an account

Sign in

Activity

Products

Explore