MySQL

[Dave Germiquet]

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