Jump to content
etsted

types in phpmyadmin

Recommended Posts

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?

Share this post


Link to post
Share on other sites

"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 by Petrucho

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

do u mean in a folder?

 

Yes.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...