Re: [PATCH] Re: blessing db data as utf8

[Gaal Yahas]

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/