Esteemed Monks,

I've got a CGI::Application based program that uses CGI::Application::Plugin::Session (which is basically a wrapper on CGI::Session) to handle the session stuff.

Recently, I wanted to change from the default encoding in mysql to UTF-8. Easy enough, just issue:

$dbh->do(qq|set names 'utf8'|);

right after the new'ng up the database handle, right?

For reasons unclear to me, this causes some craziness over in CGI::Session. Here's the error that it generates:

Error executing class callback in prerun stage: Can't locate object method "errstr" via package "CGI::Session::Serialize::storable" at /usr/lib/perl5/site_perl/5.8.6/CGI/Session.pm line 674.

Things go back to working fine if I take that line out.

I've checked to make sure that the mysql database is UTF-8 (and tables too), on the off chance that would make a difference. I also blew away any old sessions in case it might have had a problem with old data in the old character set.

Anybody have any ideas on what might be going on?

Thanks for any help you can provide!

In reply to CGI::Session and UTF-8 with Mysql? by pffan239

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.