Correction:
MYSQL uses "BIGINT" (or another type with "INT" in its name) where Oracle uses
NUMBER.
https://docs.oracle.com/cd/E12151_01/doc.150/e12155/oracle_mysql_compared.htm#BABHHAJC
The rest of what I said still stands (I think).
YMMV
The information contained in this electronic mail
If you encode your binary data as pure ascii, in and out, any database will do
just fine.
Encodings to consider are mime-64 (https://metacpan.org/pod/MIME::Base64) and
q-encoding (https://en.wikipedia.org/wiki/Quoted-printable ) - both are
lossless and can store any binary data. Hexadecimal
.
From: Kimar Miller
Sent: September 23, 2018 7:34 PM
To: dbi-users@perl.org
Subject: Tim Bunce - RE: DBD-DBI Insert Binary Files and using Perl modules in
cPanel environment
Hi Tim - How's it going?
My name is Kimar and I'm looking to find out how to go about
Hi! I do not know if it helps you, but processing binary data with MySQL
or MariaDB server and Perl's DBI can be tricky due to limitation of
MySQL protocol. Some details I wrote to the DBD::MariaDB documentation:
https://metacpan.org/pod/DBD::MariaDB#Working-with-binary-data