MYSQL

NAVIGATION
CATEGORIES
REFERRENCE
LINKS
  • UTF8-bit not set for columns with "utf8_bin" collation

    0 answers - 814 bytes - related search similar search Add To My Delicious Add To My Stumble Upon Add To My Google Mark Add To My Facebook Add To My Digg Add To My Reddit

    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


max 4000 letters.
Your nickname that display:
In order to stop the spam: 1 + 1 =
QUESTION ON "MYSQL"

EMSDN.COM