UTF8-bit not set for columns with "utf8_bin" collation
0 answers - 814 bytes -
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 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
Re: UTF8-bit not set for columns with "utf8_bin" collation