MySQL

[Jason Carson]

> 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