Home » Community » Coffee corner » saving and reading pdf file, binary file, image file in mysql
Re: saving and reading pdf file, binary file, image file in mysql [message #57090 is a reply to message #57087] |
Sun, 23 May 2021 21:10 |
BetoValle
Messages: 203 Registered: September 2020 Location: Brasil Valinhos SP
|
Experienced Member |
|
|
Hi, I had some success with pdf files:
mysql (I also successfully tested it on sqlite3)
//it may be necessary to increase mysql limits in the "my.ini" file, it was my situation because I tested a 23mb file
max_allowed_packet = 64M or (1073741824)
and
innodb_log_file_size=255M
String f="testeOrig.pdf";
String f2="testeDest.pdf";
String s=LoadFile(f);
String str=Base64Encode(s);
sql.Begin();
String st="INSERT INTO test ";
st += "(ID,TEXT,BF)";
st += " values (?,?,?)";
sql.Execute (st,1,AsString(2),str);
sql.Commit();
Value v;
String st="select * from test ";
sql.Execute (st);
while ( sql.Fetch() )
{
v = AsString ( sql["BF"] );
}
String str=Base64Decode(v);
SaveFile(f2,str);
Thanks!
|
|
|
Goto Forum:
Current Time: Fri Sep 20 11:33:57 CEST 2024
Total time taken to generate the page: 0.03023 seconds
|