List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 4 2002 4:47pm
Subject:re: Newbie question: Storing text
View as plain text  
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
>

Thread
MySQL Cookbook has been releasedPaul DuBois1 Nov
  • full-text search (not in boolean mode)ddd1 Nov
    • Re: full-text search (not in boolean mode)Paul DuBois2 Nov
  • Re: full-text search (not in boolean mode)ddd2 Nov
    • Re: full-text search (not in boolean mode)Paul DuBois2 Nov
      • Newbie question: Storing textPaul2 Nov
        • re: Newbie question: Storing textEgor Egorov4 Nov
          • re: Newbie question: Storing textPaul DuBois4 Nov
  • Replication and temp tables...Jon Frisby7 Nov
Re: Newbie question: Storing textWalter Lee Davis2 Nov
Re: Replication and temp tables...Heikki Tuuri8 Nov
  • RE: Replication and temp tables...Jon Frisby8 Nov
    • Re: Replication and temp tables...Heikki Tuuri8 Nov
Re: Replication and temp tables...Heikki Tuuri8 Nov