Re: varchar vs. text

Tom Lane wrote:

>Michael Garriss <mgarriss(at)earthlink(dot)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?