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

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

am 08.02.2007 12:33:10 von Sven Neuhaus

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/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org