Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

Re: UTF8 vs SQLite

by nothingmuch (Priest)
on Sep 24, 2005 at 22:31 UTC ( [id://494814]=note: print w/replies, xml ) Need Help??


in reply to UTF8 vs SQLite

Eventually I chose this solution:
use Data::Structure::Util qw/_utf8_on/; $some_cdbi_class->add_trigger(select => sub { _utf8_on($_[0]) });
-nuffin
zz zZ Z Z #!perl

Replies are listed 'Best First'.
Re^2: UTF8 vs SQLite
by Your Mother (Archbishop) on Jan 14, 2006 at 23:00 UTC

    Late in the game, I know.

    This is working for me too and it may be the solution I keep till the DBD::mysql is fixed. I think the recursive sub is probably not needed, right? Just the regular utf8_on instead of the _utf8_on in your sample.

      IIRC (i haven't played with this code in a while, don't have convenient access to it in the weekend) I did the recursive sub because it was already an object in the trigger.

      WRT mysql - gaal submitted a patch - use it. I heard it won't be applied because the authors would like more complete support, but it's not likely that will happen.

      -nuffin
      zz zZ Z Z #!perl

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://494814]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others rifling through the Monastery: (1)
As of 2024-04-18 23:56 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found