Re: DBD::mysql path forward
Paul DuBois <[email protected]>
| Newsgroups | gmane.comp.lang.perl.modules.dbi.general,gmane.comp.lang.perl.modules.dbi.sybase.devel |
|---|---|
| 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