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
