Hi all,

I come from a programming background, and am just starting to learn php/MySQL for the purposes of setting up an online catalogue of recepie ideas. I am doing okay in terms of learning the languages, but am having trouble importing the bulky text (like, the recepie ingredients an method) into the database. When i'm using the 'INFILE' sql function, it's only importing the first 50 or so characters.

I'm starting to think that maybe i have the approach all wrong. Should i be looking to store all this text directly into the MySQL database? or should i just store a link to a text file and have all the text seperate? What's the generally accepted rule when storing large amounts of text in a database?

Any advice you could give me would be much appreciated!

depends on how you are going to display it

personally I store the text content in a TEXT field

How do you have your DB field defined?

and here is a link that may help you.

http://www.ispirer.com/doc/sqlways38...ays-1-200.html



Colbyt