On 06.03.2001 18:43:32 Nguyen, David M wrote:
> I try to create a new table and setup a datatype for comment column that has
> about 7000 characters long. How do I define it in Oracle?
That's the MySQL mailing list, you know.... No idea how to do stuff in Oracle.
>
> **Here's my SQL and the error I got.
>
> SQL> create table test
> (comment varchar(7000));
>
> ERROR ---> Character field too long
See this? vvvvv
> http://www.mysql.com/manual.php (the manual)
^^^^^^^^
It's in there how long a varchar can be.
But before flaming starts: VarChar can take no more than 255 characters.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php