[CDBI] [Repost] Set utf8 character set on class connection?
perrin at elem.com
Mon Jan 9 20:38:26 GMT 2006
On Mon, 2006-01-09 at 21:24 +0100, Birgit Kellner wrote:
> use Class::DBI;
> package ILKB::DBI;
> use base 'Class::DBI';
> ILKB::DBI->db_Main->do("set names utf8");
The danger here is that if you lose your connection, it will reconnect,
and will not re-run that SQL. You have to override db_Main to fix that.
If you only use this in short command-line scripts and not in a
persistent environment like mod_perl, you may be okay.
More information about the ClassDBI