CODEWITHSUNDEEP
mysql
Roger Travis
Roger Travis

Reputation: 8548

do I store long strings in tables or in a separate text file?

I have a table where fields are 40 varchars long, but from time to time I would have to store text ( 250-1000 characters long ) there. What would be the best solution, to try and fit it into the table or just make a separate text file associated with each table?

Thanks!

Upvotes: 0

Views: 928

Answers (2)

AndersK
AndersK

Reputation: 36092

Better to keep everything in the database, then you don't have to jump through loops when accessing the database remotely ( or when doing backups )

Upvotes: 3

Sarfraz
Sarfraz

Reputation: 382909

You should use the text type instead of varchar there.

Upvotes: 4

Related Questions