Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW

Re: Handle UTF-8 with DBI

by valdez (Monsignor)
on Jan 03, 2006 at 20:44 UTC ( #520724=note: print w/replies, xml ) Need Help??

in reply to Handle UTF-8 with DBI

If your database was created specifying utf8 as charset, everything you will get from it will be valid utf8 but not marked as utf8; so you only need to switch on the utf8 flag on. nothingmuch posted a link to an interesting patch for DBD::mysql at node UTF8 vs SQLite.

HTH, Valerio

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://520724]
[Corion]: Hmm - actually, I don't need them, even though they'd be nice. I just want the (say) 10 latest images, and that's easily done with a limit 10 offset 0 clause, as I don't need all top 10 images for all users.
[Corion]: erix: Sure, but this is for a really-lightweight application and I'm replacing a CSV file / JSON file for user configuration with SQLite (and optionally, Pg) :)
[erix]: isn't a texty format handier for configs?
[Corion]: So far, I've avoided having even a user database by storing the user information in a (signed) cookie that the browser keeps for me, but as I want to be able to lock users, I need a second storage option :)
[Corion]: erix: It's needed for keeping the list of users and the list of tags associated with an image, and for keeping the images with users. I want an easy way to know if an image can be deleted, which means that it can't be referenced by any tag anymore. ...
[Corion]: SQL feels like a natural choice here :)

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (12)
As of 2018-03-20 14:06 GMT
Find Nodes?
    Voting Booth?
    When I think of a mole I think of:

    Results (253 votes). Check out past polls.