SQL + large amounts of text

Results 1 to 2 of 2

Thread: SQL + large amounts of text

  1. #1
    Join Date
    Dec 1969

    Default SQL + large amounts of text

    I need to store 2 lots of text in a row, problem is that the text can be larger than the row allows (8K limit), I have looked at books online until my eyes went funny and it still makes no sense. <BR><BR>I know that you need to set the columns that are going to have the large amounts of data stored in them to a "text" datatype, but how do I insert, update, select, search etc.<BR><BR>I have seen that there area few ways to do it, but none of them make any sense

  2. #2
    Join Date
    Dec 1969

    Default here

    you select them just like any other column. To insert/update, look at this sample:<BR><BR>http://www.eggheadcafe.com/PrintSearchContent.asp?LINKID=171<BR><BR>You&#039; ll also want to read this:<BR><BR>http://www.eggheadcafe.com/PrintSearchContent.asp?LINKID=309

Posting Permissions

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