On 2017-09-13 12:58 PM, Dan Book wrote:
On Wed, Sep 13, 2017 at 3:53 AM, Peter Rabbitson wrote:
On 09/12/2017 07:12 PM, p...@cpan.org wrote:
And here is promised script:
<snip>
The script side-steps showcasing the treatment of BLOB/BYTEA columns, which
was one of the main ( albeit not the only ) reason the userbase lost data.
Please extend the script with a BLOB/BYTEA test.
I'm not sure how to usefully make such a script, since correct insertion of BLOB
data (binding with the SQL_BLOB type or similar) would work correctly both
before and after the fix.
Perhaps the requirement of the extra tests is to ensure that BLOB/BYTEA data is
NOT mangled during input or output, that on input any strings with a true utf8
flag are rejected and that on output any strings have a false utf8 flag. Part
of the idea is to give regression testing that changes regarding Unicode
handling with text don't inadvertently break blob handling. -- Darren Duncan