Re: DBD::mysql path forward

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, [email protected] 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