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 re
I would agree MySQL my not be the platform you want. It is limited in what it
can do. I would give Postgress SQL a go. You have the use the 'pg_lo_???'
functions to manipulate your objects. They work quite well.
By the way saving images, mp3 etc as blobs or lobs to a DB is not used in
m
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
