On Wed, Jan 08 2014, Dave Howorth <dhowo...@mrc-lmb.cam.ac.uk> wrote:
> But when I run my DBIC program and dump the value, I see single-byte > characters such as \xA0, \x91, \x92 which I believe are Windows-1252. two things I can think of: - do your Result classes 'use utf8'? - when you dump the data (write to file), are you using an utf8 filehandle? e.g. use open ":encoding(utf8)"; or binmode(OUT, ":utf8"); other than that, I found this page quite informative: http://mysql.rjweb.org/doc.php/charcoll HTH patrick -- Patrick Meidl, Mag. Senior Expert Software Engineering IST - Institute of Science and Technology Austria Am Campus 1 A-3400 Klosterneuburg, Austria R C02.01.003 (Container 2) T +43 2243 9000 1063 E pme...@ist.ac.at W http://www.ist.ac.at/ _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk