Generating readable Reports (accent problem/encoding)

RT Users
1

I�m using RT3.4 with MySQL 5.0.30 and Perl 5.8.8.

I�ve got a serious problem with encoding.
I want to generate reports by using iReport 1.3.0 in PDF format. The
problem is that the data that I get from the database is not with the
correct encoding.
Whenever there are characters with accents, such as “�” (aacute), my
reports come out with “á”.
I took a look at the database and the accented characters where all
weird like the example above.
The RT web interface is fine and e-mails are fine too.
I�ve already tried to mess around the I18N.pm file, but I had no success.
I don�t know much of Perl, so I would really appreciate if somebody
could help me out with this.
I don�t really know wether it is a Perl problem, or a MySQL problem, an
RT bug etc…

Thanks a lot!
Mario Gomide

2

Whenever there are characters with accents, such as “�” (aacute), my
reports come out with “á”.

This is probably a conflict between RT, which likes to use UTF-8 for
everything, and whatever you’re using to display things, which probably
uses Latin-1.

Whether this is a bug or not can vary. For example, if you take a mail
message which is (correctly) marked as being UTF-8 and look at it with
a text display program, the display program normally will not parse
mail headers and thus won’t realize it’s looking at UTF-8 text. But if
you use a mail user agent to look at it, it’s much more reasonable to
consider it a bug if it doesn’t handle the header markings correctly.

I took a look at the database and the accented characters where all
weird like the example above.
The RT web interface is fine and e-mails are fine too.

This is exactly what I’d expect: the Web browser, and the email client,
are handling UTF-8 correctly, but whatever you used to display the
output of your database query was not.

I don?t really know wether it is a Perl problem, or a MySQL problem,
an RT bug etc…

Based on just your descriptions, I’d say it’s most likely a bug at the
human-expectation level. :slight_smile:

/~\ The ASCII der Mouse
\ / Ribbon Campaign
X Against HTML mouse@rodents.montreal.qc.ca
/ \ Email! 7D C8 61 52 5D E7 2D 39 4E F1 31 3E E8 B3 27 4B