|Subject:||No UTF-8 support|
DBD::mysql provides no way to get values from the database as strings with the UTF8 flag set. There should be an option which can be passed to connect() to make this happen when appropriate. Of course, the strings may or may not be UTF8. One possible solution might be to have a single option which sets the conncetion character set to UTF8 like this: $dbh->do("set names 'utf8'"); and then turns on UTF8 flags on strings returned from SELECT statements. MySQL will convert everything it sends to UTF-8, so it would then be appropriate to pass things off to Perl with the UTF8 flag on. Note that DBD::Pg has a feature for turning on UTF8 flags, so code could be borrowed from there. According to the Changes file it was added in version 1.22.