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

[Steve Hay]

Jochen Wiedmann wrote:

>Good patch, in particular because it includes the docs!
>
Rudy Lippan already did something similar to this, but never released it 
to CPAN.  Here are links to a couple of threads discussing it:

http://marc.theaimsgroup.com/?t=106321975700026&r=1&w=2
http://www.mail-archive.com/dbi-users@ style="color:#666">stripped/msg18360.html

He sent me a tarball containing his patched version, which he called 
2.9003_2.  I still have it if anybody wants it.

I haven't actually started using it yet.  I want to see how things turn 
out with all the new character set support stuff in 4.1.x.  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?

Are there any plans to have DBD::mysql hook into the new charset stuff 
in 4.1.x and (for example) automatically handle UTF-8 data properly for 
columns/tables/databases marked within MySQL itself as UTF-8?

- Steve



------------------------------------------------
Radan Computational Ltd.

The information contained in this message and any files transmitted with it are
confidential and intended for the addressee(s) only.  If you have received this message
in error or there are any problems, please notify the sender immediately.  The
unauthorized use, disclosure, copying or alteration of this message is strictly
forbidden.  Note that any views or opinions presented in this email are solely those of
the author and do not necessarily represent those of Radan Computational Ltd.  The
recipient(s) of this message should check it and any attached files for viruses: Radan
Computational will accept no liability for any damage caused by any virus transmitted by
this email.