SQL Database Question - BLOB
 

Is there any reason that I shouldnt just set all fields in a table as 'BLOB' in terms of server usage, security, etc?

It could use up a lot of data and might mess up your backups depending on how you have them set up, tho.

...I might be thinking about people who have done this before, but were storing files in the DB when they shouldn't be in there lol.

This is just for text based content, from what I've been reading, theres a camp that says it doesnt really matter, and another that says it may do what you said, but nobody has actually been able to provide evidence that it effects backups that have that train of thought, other than with images.

I'm just honestly annoyed that I keep having to change these settings anytime I throw a new table together and cant just copy and paste in the info to create them lol

Yes i think i read somewhere how it's bad to use it so i never used it so cant really tell . But i am used anyway to limitation of characters and type of input so no need for it anyway. That is handy to prevent "surprise" injections.

It's useful if you want to store like any type of character set in a field, or if you want to store a file in the database. It's useful sometimes.

It does sometimes cause issues with backups/mysqldump etc, though