UTF8-bit not set for columns with "utf8_bin" collation

Sven Neuhaus <[email protected]>
Newsgroups gmane.comp.db.mysql.perl
Organization Heise Zeitschriften Verlag GmbH & Co. KG
Message-ID <[email protected]>
Hello folks,

I'm using the latest and greatest DBD::mysql 4.001 and connect to the
database with the "mysql_enable_utf8" flag set.

I noticed that the UTF-8-bit in perl is set correctly for data fetched from
columns with the collations utf8_general_ci and utf8_unicode_ci, but not for
the collation utf8_bin (which is currently the only case-sensitive collation
for UTF-8).

I opened a bug for this issue at
http://rt.cpan.org/Public/Bug/Display.html?id=24738
but didn't get a reaction yet so I thought I'd bring it up here, too.

I looked at the source code, but it merely seems to call
sv_utf8_decode() in dbdimp.c line 3559.
I'm not sure why this fails with utf8_bin collation. Perhaps
the data isn't even of type MYSQL_TYPE_STRING with this collation?

Regards,
-Sven Neuhaus

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.