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/description for the purpose of retrieving
>P> it on the website. What would be the most appropriate way to store it?
>P> Text or long varchar (something like varchar(1000)?
>
>P> Which field supports full text search?
>P> Hob about if I want to store the description that is html formatted?
>P> Would that choice differ (TEXT/VARCHAR)?
>
>There is no long varchar in MySQL. You can find the maximum length for
>all column types here:
> http://www.mysql.com/doc/en/Column_types.html
>
>Full-text search is supported on VARCHAR() and TEXT columns.
And CHAR().
>
>
>
>--
>For technical support contracts, goto https://order.mysql.com/?ref=ensita
>This email is sponsored by Ensita.net http://www.ensita.net/
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Egor Egorov
> / /|_/ / // /\ \/ /_/ / /__ Egor.Egorov@stripped
>/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
> <___/ www.mysql.com
>
