Almacenar imagenes / documentos en MySQL

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

Post Reply
User avatar
mjaviergutierrez
Posts: 156
Joined: Fri Nov 30, 2012 7:51 pm
DBs Used: DBF
Location: San Lorenzo, Santa Fe, Argentina

Almacenar imagenes / documentos en MySQL

Post by mjaviergutierrez »

Hola Colegas !
Estoy averiguando para almacenar imágenes (jpg,png,bmp las mas estándares), y documentos (pdf, word, txt) en una base de datos MySQl, alguien ya tuvo la experiencia ? , no encontre ningun post ... si alguien sabe algo, les agradeceré un montón.
Saludos !
...
User avatar
Rathinagiri
Posts: 5480
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: Almacenar imagenes / documentos en MySQL

Post by Rathinagiri »

Sure, we can save any file as a BLOB (Binary Large OBject). Easiest way is to encode a file into base64 string and decode into a file whenever required.

Use this code to encode/decode.
Attachments
base64.zip
(521 Bytes) Downloaded 175 times
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
mjaviergutierrez
Posts: 156
Joined: Fri Nov 30, 2012 7:51 pm
DBs Used: DBF
Location: San Lorenzo, Santa Fe, Argentina

Re: Almacenar imagenes / documentos en MySQL

Post by mjaviergutierrez »

Ok, gracias Rathinagiri, voy a hacer las pruebas y comento como me fué. Muchas Gracias. Saludos a todos !
...
User avatar
mjaviergutierrez
Posts: 156
Joined: Fri Nov 30, 2012 7:51 pm
DBs Used: DBF
Location: San Lorenzo, Santa Fe, Argentina

Re: Almacenar imagenes / documentos en MySQL

Post by mjaviergutierrez »

Hola !!, testeado , funciona Ok
Muchas Gracias Rathinagiri
Saludos a todos.
...
Post Reply