[Dbix-class] Unicode woes

[Patrick Meidl]

On Wed, Jan 08 2014, Dave Howorth <dhoworth at 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 pmeidl at ist.ac.at
W http://www.ist.ac.at/