Re: DBD::mysql path forward

[email protected] (Paul DuBois) Thu, 14 Sep 2017 19:24:02 -0600

Newsgroups	perl.dbi.dev,perl.dbi.users
Message-ID	<[email protected]>

> 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