re: Newbie question: Storing text

2002-11-04 Thread Paul DuBois
At 19:15 +0200 11/4/02, Egor Egorov wrote: Paul, Saturday, November 02, 2002, 5:11:43 PM, you wrote: P> I am kind of new to MySQL. I have ordered MySQL Cookbook but I still P> have a week before it arrives. In the meantime, I am looking for some P> basic help. P> I am looking to store the text/d

re: Newbie question: Storing text

2002-11-04 Thread Egor Egorov
Paul, Saturday, November 02, 2002, 5:11:43 PM, you wrote: P> I am kind of new to MySQL. I have ordered MySQL Cookbook but I still P> have a week before it arrives. In the meantime, I am looking for some P> basic help. P> I am looking to store the text/description for the purpose of retrieving P>

Re: Newbie question: Storing text

2002-11-02 Thread Walter Lee Davis
VARCHAR is limited to 256 characters. TEXT is much longer, like 6000 or 6 characters or so, don't actually know. I believe both TEXT and varchar both support full text searches. You can store HTML in the database, just be sure to addslashes and stripslashes going in and out. Your server may be

Newbie question: Storing text

2002-11-02 Thread Paul
Hi All: I am kind of new to MySQL. I have ordered MySQL Cookbook but I still have a week before it arrives. In the meantime, I am looking for some basic help. I am looking to store the text/description for the purpose of retrieving it on the website. What would be the most appropriate way to stor