Results 1 to 2 of 2

Thread: help.

  1. #1
    Join Date
    May 2006
    Posts
    5

    Unanswered: help.

    I am doing on an online music store and I have 40+ artistes in my database. Each artist has a bio (paragraphs of information about his life). How do I accomodate all the bios in my database? I am using MS SQL Server 2005.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    You can use the VARCHAR datatype to store up to 8000 characters (4000 in unicode).
    You can use the TEXT datatype to store unlimited string data, but you are then somewhat limited in your ability to query and search this data.
    In SQLSVR 2500 you can use the new VARCHAR(MAX) datatype.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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