Re: DBD::mysql path forward

Hi Paul! (long time!)

we need to make sure we have these cases accounted for and test coverage.

regards,

Patrick

On 9/14/17 9:24 PM, Paul DuBois wrote:
>> On Sep 14, 2017, at 1:44 AM, [email protected] wrote:
>>
>> MySQL server and its databases has some limitations, so reflect it:
>>
>> * it does not provide information if placeholder is TEXT, VARCHAR, VARBINARY or BLOB
>> * placeholder's bind value does not have to point to column, it can be also SQL function
>>   --> for caller/user all placeholders are equivalent and caller itself
>>       needs to know how to treat bind variable and needs to specify if
>>       it is TEXT or BLOB
>>
>> * VARBINARY is right padded with 0x00
>>   --> there is no difference between binary "\x01\x02\x00" and "\x01\x02"
> BINARY is padded (for storage), VARBINARY is not.
>
> https://dev.mysql.com/doc/refman/5.7/en/binary-varbinary.html