From: Date: June 10 2004 8:17pm
Subject: Re: [PATCH] Re: blessing db data as utf8
List-Archive: http://lists.mysql.com/perl/3012
Message-Id: <20040610181728.GN17923@sike.forum2.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

On Thu, Jun 10, 2004 at 11:45:07AM +0100, Steve Hay wrote:

> Getting UTF-8 data stored in the database back into properly flagged Perl 
> strings without mangling anything is only part of the problem.  How do 
> you perform SQL SELECT's on such data in the database without the 
> database understanding that the bytes it is storing are UTF-8 characters?

Having the database knowing about utf8 is (very) nice to have, but it
isn't essential. '=' and LIKE should continue to work thanks to the
cleverness of utf8; of course, collating and therefore ORDER BY won't
work correctly either, and the sizes the database knows about will all
be in bytes instead of characters. Bothersome but not insurmountable. :)

-- 
Gaal Yahas <gaal@stripped>
http://gaal.livejournal.com/