Before testing end-to-end figure out if the chars from your database are *really* utf-8. I forgot to set an env var for the oracle client library to tell it I want unicode which broke my app under fcgid.
If you're using DBIx::Class to access your database see http://www.perlmonks.org/?node_id=736234. -- Best regards, Alex Am Montag, den 25.01.2010, 13:43 +0100 schrieb Jens Schwarz: > Hi, > > first of all: I have read > http://dev.catalystframework.org/wiki/tutorialsandhowtos/Using_Unicode > (especially the "Tips for Troubleshooting Unicode in Perl Web Applications") > Nevertheless I have a strange UTF-8 problem that I need help with: > > Concerning UTF-8 everything in my App seems to work correct - except my mail > action (I use Mail::Sender::Easy) in my Root controller: > > <code> > (...) > use Mail::Sender::Easy qw(email); > use utf8; > (...) > sub mail :Private { > (...) > $mail_return = email({ > (...) > 'subject' => (... something from the database ...), > '_text_info' => { > charset => 'utf-8', > encoding => 'quoted-printable', > }, > '_text' => (... some text with literal UTF-8 characters NOT from the > database ...), > (...) > }); > (...) > } > </code> > > This produces mails that have messed up UTF-8 characters although the charset > is set in the mail header, and the clients (right now tested with Thunderbird > 3 and Outlook 2003) are configured to treat incoming mails as utf-8 encoded > text. Strange: If I switch to ISO8859-1 in Thunderbird, the mails look > alright. Outlook however simply drops the UTF-8 characters, so that p.ex. the > German sentence "Nachricht für Herrn Müller" results in "Nachricht fr Herrn > Mller". > If I remove the "use utf8", the UTF-8 characters that do NOT come from the > database look fine (in the example above: everything in '_text'), the ones > from the database are messed up (in the example above: everything in > 'subject'). Removing the "charset => 'utf-8'" flag of the mail subroutine > results in fine mails if I set the charset to ISO8859-1 in the clients. > > To summerize: I have UTF-8-tifized everything that I am aware of - i.e.: > - Editor where the source code is produced > - source code itself > - in the MySQL database every table is set-up with UTF-8 Unicode charset and > utf8_general_ci collation. > - the webbrowsers > - the email clients > - Catalyst ("use utf8", "UTF8Columns") > - Template Toolkit ("View::TT => {ENCODING => 'UTF-8'} ") > - FormFu ("tt_args => {ENCODING => 'UTF-8'}") > > Any hints on where the problem might be? > Thanks > > Jens *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* T-Systems Austria GesmbH Rennweg 97-99, 1030 Wien Handelsgericht Wien, FN 79340b *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* Notice: This e-mail contains information that is confidential and may be privileged. If you are not the intended recipient, please notify the sender and then delete this e-mail immediately. *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* _______________________________________________ List: Catalyst@lists.scsys.co.uk Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/ Dev site: http://dev.catalyst.perl.org/