Hi,
I'm wondering what kinds of tables people use for their text data.
I'm building a site and storing the articles in TEXT fields - I don't have my computer with the specifics on right now, but I think TEXT medium.
But someone writing an article here on quick&dirty search engines for MySQL and PHP sites said that he stored his content in BLOBs.
What's best? What are the advantages or disadvantages?
I just started with MySQL about a month ago, and it's totally my first db experience ever, so I'd appreciate hearing what people are using, and giving me some guidance before I go live on what I should be using.
The last thing I want is to be live with most content in and start having problems with not enough room in my tables, etc.
Thanks!
-john
I'm wondering what kinds of tables people use for their text data.
I'm building a site and storing the articles in TEXT fields - I don't have my computer with the specifics on right now, but I think TEXT medium.
But someone writing an article here on quick&dirty search engines for MySQL and PHP sites said that he stored his content in BLOBs.
What's best? What are the advantages or disadvantages?
I just started with MySQL about a month ago, and it's totally my first db experience ever, so I'd appreciate hearing what people are using, and giving me some guidance before I go live on what I should be using.
The last thing I want is to be live with most content in and start having problems with not enough room in my tables, etc.
Thanks!
-john