ISO-8859-1 not working in UNIX machine

[jyobeer]

Hi ,

I am using character encoding as ISO-8859-1 while exporting data to csv.

Its working fine in my local system (Windows) but fails in my Dev box which runs in unix.

The symbol comes up as ? in unix box in csv file.

Please help so that i can close the issue.

 

Thanks

Jitu

[jyobeer]

Hi,

Missed some informations.

I am trying to show different currency symbols in csv file which comes up as ? mark even after ISO-8859-1 encoding

Please help

 

Thanks

Jitu

[mgeise]

 Just a guess, but it could be a font issue.  The Microsoft fonts are likely being used on your windows system and if they are not available to your JVM on your Unix system, then the fall back fonts may not have matching symbols.  You could try creating a font extension and adding it to your classpath.

[jyobeer]

Hi,

Thanks for the quick reply.

I am getting the symbols perfectly in pdf and excel sheets while exporting.

But the issue i am getting is only in csv files.

Do you still think this might be a font issue.

If so please tell me how to create a font extension.

 

Thanks

Jitu

[jyobeer]

Hi,

I just found out that only euro symbol is not comming up in csv all other symbols are comming up like yen and pound.

 

Thanks

Jitu

[mgeise]

Try packaging up the Arial font as an extension by doiing the following:

1. Open up iReport on your windows machine

2. Go to tools->Options

3. Under iReport, you will see a tab called Fonts, click on it

4. Click install font

5. Browse for the ttf file for arial, click next

6. Set the Font name (to Arial) and browse for the bold(bd), italic(i), and bold italic(bi) ttf files for arial

7. Click finish

8. Select the font and click export as extension to create a jar file

Add this jar to your JVM classpath and make sure your report is using Arial as your font.

 

See if that works.

 

[jyobeer]

Hi,

I tried exporting the font and placed it on my local tomcat which is running on WINDOWS machine.

But no change.Am still getting the same  ¤ symbol for EURO (€).

Please let me know if i can fix this in some other way.

 

Thanks

Jitu