[Bug 218391] databases/p5-DBD-mysql: version 4.042 broke utf-8 support of www/otrs

[bugzilla-noreply at freebsd.org]

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=218391

            Bug ID: 218391
           Summary: databases/p5-DBD-mysql: version 4.042 broke utf-8
                    support of www/otrs
           Product: Ports & Packages
           Version: Latest
          Hardware: Any
                OS: Any
            Status: New
          Severity: Affects Some People
          Priority: ---
         Component: Individual Port(s)
          Assignee: freebsd-ports-bugs at FreeBSD.org
          Reporter: topical at gmx.net
                CC: m.tsatsenko at gmail.com, perl at FreeBSD.org
                CC: m.tsatsenko at gmail.com, perl at FreeBSD.org

After upgrading databases/p5-DBD-mysql, otrs-5.0.14 doesn't work properly
anymore. Prepared statement SQL INSERT commands seem to encode UTF-8 characters
wrongly, leading to SQL errors like:

"Incorrect string value: '\xE4re]' for column 'data_
key' at row 88, SQL: 'INSERT INTO sessions (session_id, data_key, data_value,
se
rialized) VALUES (?,?,?,?), ..."

Downgrading p5-DBD-mysql to 4.041 fixes this. Digging into SVN changelog shows
that UTF-8 support was kind of rewritten and I suspect that they effectively
broke it at least when it comes to prepared statements.

-- 
You are receiving this mail because:
You are on the CC list for the bug.