CREATE OR REPLACE DATABASE `my-database` CHARACTER SET = 'utf8mb3' COLLATE = 'utf8mb3_general_ci';
Why would TO_BASE64 care about the character set? That sounds like a bug if it does.
There are no instructions on how to properly do this. The help page only talks about converting a string to BASE64, not a BLOB.
I take the result from a development tool (I think an ODBC driver), from the command line, and Thunder Test in VSCODE using MariaDb's node driver and all fail when I copy them to a website that converts BASE64 to an image.
This converts it every time in the Node.js / Express.js server we use:
var strBase64 = dbResponse[0][0].UserPictureBlob.toString("base64");
I copy the string to the webpage and the image shows up every time without error.
Merged from MySQL-5.6. to MariaDB-10.0.5