Whats the suitable data type for the qr code in mysql?

Question

Am trying to feed the qr image with data so that when it is displayed and scanned all the inserted data should be displayed.

Answer 1

Sekela Mututa We never store qr code image in database. There is some features by which we can create qr code like we can use node js framework to make qr code.

Check here how to generate QR Code.

http://thecodebarbarian.com/creating-qr-codes-with-node-js.html

Answer 2

If you want to store the qr code as image, you can use the BLOB type (binary large object).
If you want to store the actual meaning encoded in the image, then you may need multiple columns, as the content could be quite complex, a serial number, an url address, even a hierarchical structure of objects (like vCard).

Answer 3

Thank you so much, I really appreciate.