9 messages in com.mysql.lists.perlRe: What to do with UTF-8 data?
FromSent OnAttachments
Steve Hay10 Sep 2003 08:50 
Tim Bunce11 Sep 2003 03:48 
Steve Hay11 Sep 2003 04:31 
Bart Lateur11 Sep 2003 07:25 
Rudy Lippan11 Sep 2003 08:56 
Steve Hay11 Sep 2003 10:09 
Rudy Lippan11 Sep 2003 10:36 
Steve Hay12 Sep 2003 00:58 
Steve Hay06 Oct 2003 03:15 
Subject:Re: What to do with UTF-8 data?
From:Tim Bunce (Tim.@pobox.com)
Date:09/11/2003 03:48:51 AM
List:com.mysql.lists.perl

On Thu, Sep 11, 2003 at 08:29:50AM +0200, Jochen Wiedmann wrote:

Hi, Steve,

The problem is: How do I trap all input/output to/from DBI to do these conversions?

I've asked about this on the dbi-users mailing list, and the answer (from Tim Bunce, no less) was that it is really the responsibility of the DBD driver to perform such conversions if the data in question is UTF-8.

That's not quite right. I wasn't talking about any _conversions_ at all.

after letting my thoughts settle I come to the conclusion that I do not agree completely. I think that DBI should do 80% of the job and leave about 20% to the driver authors.

For a "full solution" yes, I agree - and I've written about this in the past.

For now I'm just talking about the specific but fairly common situation of fetching data that is utf8 encoded but it doesn't get flagged as such by the driver.

For that case the driver just needs to know when to do a SvUTF8_on(sv).

Tim.