in reply to UTF8 vs SQLite

I'm struggling through some utf-8 issues myself, and the best explanation I found (since I found the perl docu overwhelming) was at Unicode-processing issues in Perl and how to cope with it

The general strategy this page suggests for dealing with unicode in perl 5.8 is 

    $_ = Encode::decode_utf8( $_ );

[download]
This was for a cgi context, but it seems to me it should be applicable to all input from wherever. I suspect, but am not certain, this is doing the same thing, or something similar, to what corion suggested.

Replies are listed 'Best First'.
Re^2: UTF8 vs SQLite
by nothingmuch (Priest) on Sep 14, 2005 at 09:30 UTC
    The actual conversion is not what I'm trying to get done. What I want is for the conversion to be done automatically at a level much lower than I care to fiddle with.

    Corion's Class::DBI trigger idea is probably the best, but I'd like to be able to do it at the DBI level if possible, since the DBH should really be losslessly relaying data I send to and from it and Class::DBI should not be touch that.

    -nuffin
    zz zZ Z Z #!perl
[reply]

In Section Seekers of Perl Wisdom