Insert base64 string to blog mysql with node.js

Question

I want to insert a base64 string into a mysql blog. To do it, I use the code below but when I run the code I have the following error:

ER_DATA_TOO_LONG: Data too long for column 'Immagine' at row 1

Immagine is base64 image(png or jpg)

Node.js Code:

async function inserimentoTipologia(Nome, Immagine) {
    var ret = true;
    var imgCast = new Buffer.from(Immagine, "base64");
    checkValueLoad = await new Promise((resolve, reject) => {
        return db.con.query("Insert into Categoria(Nome,Immagine) values( ? , ? ); ", [Nome, imgCast], function(err, results) {
            if (err) {
                ManageError.SendError("Errore: nella funzione inserimentoTipologia " + err);
                ret = false;
            }
            resolve(true);
        });
    });
    return ret;
}

Your not inserting a base64 string - imgCast is a Buffer. Of what type is Imagine? — eol
– eol, Commented Oct 8, 2020 at 9:44
Agree with @eol. . What type you set for Immagine column? And second try like this : const imgCast = new Buffer.from(Immagine).toString('base64'). — Mykola Borysyuk
– Mykola Borysyuk, Commented Oct 8, 2020 at 9:45

Mateusz Duma-Kurtas · Accepted Answer · 2020-10-08 09:56:19Z

1

    var ret = true;
    checkValueLoad = await new Promise((resolve, reject) => {
        return db.con.query("Insert into Categoria(Nome,Immagine) values( ? , ? ); ", [Nome, Buffer.from(Immagine).toString('base64')], function(err, results) {
            if (err) {
                ManageError.SendError("Errore: nella funzione inserimentoTipologia " + err);
                ret = false;
            }
            resolve(true);
        });
    });
    return ret;
}

answered Oct 8, 2020 at 9:56

Mateusz Duma-Kurtas

423 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Insert base64 string to blog mysql with node.js

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related