#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    Chennai,TamilNadu,India
    Posts
    33
    Rep Power
    14
    Actually varchar supports only 256 character. i want a data type that will support more than 1000 characters. Is there any data type like varchar that supports my requirement.

    TA
    Raghu.
  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    19
    RTFM

    text - 2^16-1 characters
    mediumtext - 2^24-1 characters
    longtext - 2^32-1 characters

    These datatypes cannot be indexed.
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    Chennai,TamilNadu,India
    Posts
    33
    Rep Power
    14
    <BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by rod k:
    RTFM

    text - 2^16-1 characters
    mediumtext - 2^24-1 characters
    longtext - 2^32-1 characters

    These datatypes cannot be indexed.
    [/quote]

    I've tried with text in create table. Its not working.

    My create table is:
    create table table_name(col_name text(1000));
    gives an error:
    parse error near '(1000))' at line 1

    Raghu.
  6. #4
  7. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    19
    Did you RTFM?

    You can't set the size of a text datatype.

Similar Threads

  1. Need to substitute pattern match for string
    By VytamynJ in forum Perl Programming
    Replies: 3
    Last Post: February 10th, 2004, 09:46 AM
  2. Replies: 2
    Last Post: August 1st, 2003, 10:55 PM
  3. Substitute for Perl?
    By vb.net in forum Perl Programming
    Replies: 3
    Last Post: May 11th, 2003, 02:48 PM
  4. header("Location:") substitute ???
    By Fekkesh in forum PHP Development
    Replies: 5
    Last Post: September 24th, 2002, 05:48 PM
  5. Replies: 0
    Last Post: July 13th, 2001, 02:04 PM

IMN logo majestic logo threadwatch logo seochat tools logo