MySQL

[Tyler Aviss]

Yes.
You can use a "TEXT" value for really long text values, such as input
from a textarea, etc

On Thu, Jul 16, 2009 at 10:47 PM, Dave Germiquet<davegermiquet-Re5JQEeQqe8AvxtiuMwx3w at public.gmane.org> wrote:
> Isn't there also a TEXT option for mysql?
>
> On Thu, Jul 16, 2009 at 9:23 PM, Jason Carson<jason-HjkH5KTEMfuEjziKL+yzSg at public.gmane.org> wrote:
>>> Jason
>>>
>>> 2009/7/16 Jason Carson <jason-HjkH5KTEMfuEjziKL+yzSg at public.gmane.org>
>>>
>>>> Hello everyone,
>>>>
>>>> When creating a table in MySQL varchar supports a length of up to 255
>>>> characters. Does anybody know what I use if I want to support say 10000
>>>> or
>>>> even higher?
>>>>
>>>
>>> Try varchar2
>>>
>>>>
>>>> Thanks
>>>>
>>>> Jason
>>>>
>>>
>>> William
>>>
>>
>> I came across this (http://dev.mysql.com/doc/refman/5.0/en/char.html) and
>> if you are using MySQL 5.0.3 or newer (which I am) then the length can be
>> up to 65535.
>>
>> Is there any reason to use varchar2 over varchar or vice versa?
>>
>> --
>> The Toronto Linux Users Group.      Meetings: http://gtalug.org/
>> TLUG requests: Linux topics, No HTML, wrap text below 80 columns
>> How to UNSUBSCRIBE: http://gtalug.org/wiki/Mailing_lists
>>
>
>
>
> --
>
>
>
> Dave Germiquet
> --
> The Toronto Linux Users Group.      Meetings: http://gtalug.org/
> TLUG requests: Linux topics, No HTML, wrap text below 80 columns
> How to UNSUBSCRIBE: http://gtalug.org/wiki/Mailing_lists
>



-- 
Tyler Aviss
Systems Support
LPIC/LPIC-2
(778) 890-0942
--
The Toronto Linux Users Group.      Meetings: http://gtalug.org/
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://gtalug.org/wiki/Mailing_lists