Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
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 Go to previous messageGo to previous message
BetoValle is currently offline  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!


 
Read Message
Read Message
Read Message
Previous Topic: select file with windows explorer
Next Topic: Compile under Mac M1 for intel
Goto Forum:
  


Current Time: Fri May 10 09:56:07 CEST 2024

Total time taken to generate the page: 0.02507 seconds