#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2000
    Posts
    1
    Rep Power
    0
    hello,

    I've just a little problem (i'm a newbie)
    I try to create a table with a colum of type TEXT
    and it does'nt work
    that is my code
    CREATE TABLE test (
    montest TEXT)
    and it says to me arse error
    and it works if i do :
    CREATE TABLE test (
    montest BLOB)

    what's wrong and what must I do

    thanks

    Vince

    ------------------
    VinceFrance
  2. #2
  3. .Net Developer
    Devshed Novice (500 - 999 posts)

    Join Date
    Feb 2000
    Location
    London
    Posts
    987
    Rep Power
    15
    vroques,

    <<< Text column type will work in mysql.>>>>


    As per your storage requirment you can select your columntype.

    if you want to store string(characters)in a column(with 1-255 characters).
    You can use eigther char or varchar type.

    eg;

    CREATE TABLE test (
    montest varchar(30));


    if you are using BLOB ,then you can use the column with a maximum length of 65535 (2^16 - 1) characters.

    See Mysql manual for getting details about column types.

    ------------------
    SR -
    shiju.dreamcenter.net

    [This message has been edited by Shiju Rajan (edited May 01, 2000).]
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 1999
    Location
    SLC, UT, USA
    Posts
    47
    Rep Power
    15
    I'm sorry but I have to disagree. I'm using the text type in several MySQL dabases right now. I did define it in lower case though I don't believe that makes a difference.

    Robman
  6. #4
  7. .Net Developer
    Devshed Novice (500 - 999 posts)

    Join Date
    Feb 2000
    Location
    London
    Posts
    987
    Rep Power
    15
    Robman,

    sorry, text column type will work in mysql.
    I given that statement with oracle experience.

    thank you....


    ------------------
    SR -
    shiju.dreamcenter.net

Similar Threads

  1. problem in updating data type for datetime
    By poison_ivy in forum ASP Programming
    Replies: 5
    Last Post: June 23rd, 2004, 03:51 AM
  2. [urgent]C programming: data type conversion
    By bythesea in forum C Programming
    Replies: 5
    Last Post: January 18th, 2004, 09:34 AM
  3. Javascript scrollbar - stuck on last bit
    By NayMyoSan in forum JavaScript Development
    Replies: 0
    Last Post: January 3rd, 2004, 12:05 PM
  4. Problem with dynamic text fields
    By Wallabee in forum PHP Development
    Replies: 6
    Last Post: November 21st, 2003, 05:20 PM
  5. Truncating text from a text data type
    By joebankz in forum MySQL Help
    Replies: 1
    Last Post: February 22nd, 2001, 09:30 PM

IMN logo majestic logo threadwatch logo seochat tools logo