How to create columns with 13,000 characters in it ?

Discussion in 'MySQL' started by poseidon, Jan 30, 2006.

  1. #1
    I am still searching in the google and in forum for a proper solution.

    Google says I can have atmost 65,000 characters but mysql is giving errors saying varchar(13000) is too much :D it is giving error #1074 and saying insted of varchar use BLOB..now how to use BLOB ? I also tried to use TEXT but still same error..:mad:
     
    poseidon, Jan 30, 2006 IP
  2. n0other

    n0other Peon

    Messages:
    146
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #2
    n0other, Jan 30, 2006 IP
  3. poseidon

    poseidon Banned

    Messages:
    4,356
    Likes Received:
    246
    Best Answers:
    0
    Trophy Points:
    0
    #3
    yup it's working now :) actually I was giving something like TEXT(13000) instead of just TEXT :p
     
    poseidon, Jan 30, 2006 IP