Database character sets

[prev] [thread] [next] [Date index for 2005/02/22]

I'd like to use Class::DBI and a database to store character sequences, 
as opposed to bytes, specifically I'd like things in the database to be 
encoded as utf-8 byte sequences everywhere. Although mysql4.1, which is 
my current development target, claims to support character sets on 
tables, it doesn't look like DBD::mysql knows how to deal with this. 
Anyway, it may be that we're moving DB servers, and I don't want to 
have to require that the new server knows about them.

Is this a solved problem yet? I'm hoping that it _must_ be, but I can't 
find anything in the archives of this list or the wiki about it.


tom