Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2008
    Posts
    20

    Unanswered: memo column data type

    I need a memo column in my customer table to record useful information related to this customer. The information may be few setences but could be few paragraph. I am not sure what's the data type should be for this column? varchar but how big? is any length limitation for the varchar? thanks,

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Depends on your RDBMS and also (possibly) the version.

  3. #3
    Join Date
    Jun 2008
    Posts
    20
    right now i am using MySQL version 5.0.45.

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Ok doke - I'm gonna move the thread young (wo)man since it is an implementation rather than a theoretical issue.

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    you may be better with the blob/text types
    as ever the manuel is your amigo
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •