Re: varchar vs. text

Tom Lane wrote:

>Michael Garriss <mgarriss@earthlink.net> writes:
>
>
>>I curious about the benefits of a varchar over text.
>>
>>
>
>1. Compliance to the letter of the SQL spec.
>2. Ability to define a maximum length, if you happen to feel the need to
>   impose a specific maximum length.  (If you don't have a good reason
>   to impose any particular max length, this is a minus not a plus,
>   because the spec says you have to pick one anyway.)
>
>
>
>>Is it speed,
>>
>>
>
>It's a loser on speed because of the extra cycles spent to check the
>max length.  Other than those cycles, there is no difference.
>
>            regards, tom lane
>
>
>
Thanks for the quick response.

Michael

P.S.  The code I'm writing is going to be ported to MySQL by a friend.
Do you have any idea if TEXT is supported over there?