etsted Posted March 24, 2014 Share Posted March 24, 2014 when people upload image or video to my site, do i store them in any special type in phpmyadmin? are you supposed to use BLOB? What is BLOB? Which of them do i use? I would guess they can store different amount of data, how much do each of them store? Link to comment Share on other sites More sharing options...
Petrucho Posted March 24, 2014 Share Posted March 24, 2014 DB's save textual data, not videos/imgs. You can save the path to your files, on your DB table though. Link to comment Share on other sites More sharing options...
etsted Posted March 24, 2014 Author Share Posted March 24, 2014 But if i save an address that refers to my image or video, should it be in a BLOB type? I mean what is BLOB. Answer my above questions. Link to comment Share on other sites More sharing options...
Petrucho Posted March 24, 2014 Share Posted March 24, 2014 (edited) "TEXT and CHAR or nchar that will typically be converted to plain text so you can only store text like strings. BLOB and BINARY which mean you can store binary data such as images simply store bytes." Here Edited March 24, 2014 by Petrucho Link to comment Share on other sites More sharing options...
Ingolme Posted March 24, 2014 Share Posted March 24, 2014 DB's save textual data, not videos/imgs. You can save the path to your files, on your DB table though. Databases can save any type of data. The BLOB field stands for Binary Large OBject and can be used to store the contents of any file including image or video. Given that, I still find it preferrable to store file data in the filesystem rather than the database. Link to comment Share on other sites More sharing options...
etsted Posted March 25, 2014 Author Share Posted March 25, 2014 Databases can save any type of data. The BLOB field stands for Binary Large OBject and can be used to store the contents of any file including image or video. Given that, I still find it preferrable to store file data in the filesystem rather than the database. do u mean in a folder? Link to comment Share on other sites More sharing options...
Ingolme Posted March 25, 2014 Share Posted March 25, 2014 do u mean in a folder? Yes. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now