List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:April 6 1999 11:48am
Subject:Re: varchar vs text
View as plain text  
At 4:47 AM -0500 4/6/1999, Michael Widenius wrote:
>>>>>> "Sasha" == Sasha Pachev <sasha@stripped> writes:
>
>Sasha> Is there any difference in performance between varchar
>Sasha> and text?
>
>Hi!
>
>Yes;  VARCHAR is slower.
>
>This is documented in the MySQL manual; Search after 'fixed size
>rows'!


Huh?  varchar and text data types are both variable length.

--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
Thread
varchar vs textSasha Pachev5 Apr
  • varchar vs textMichael Widenius6 Apr
    • Re: varchar vs textPaul DuBois6 Apr
  • Re: varchar vs textSasha Pachev6 Apr
    • Full text search?Fraser MacKenzie6 Apr
      • Re: Full text search?Thimble Smith6 Apr
        • Re: Full text search?Michael Widenius10 Apr
    • Re: varchar vs textMichael Widenius10 Apr