MEMO field in SQL????

Results 1 to 6 of 6

Thread: MEMO field in SQL????

  1. #1
    Fat Joey Guest

    Default MEMO field in SQL????

    Is there an SQL equivalent to the memo field in Access. If not any suggestions?

  2. #2
    RDM Guest

    Default nText


  3. #3
    Fat Joey Guest

    Default RE: nText

    Thanks, How much data can this hold?

  4. #4
    RDM Guest

    Default Up to 2GB...

    Take a look at the help in the SQL Server Enterprise manager.<BR>Search for nText and you&#039;ll get several items that talk about advantages, disadvantages, and limitations that my apply.

  5. #5
    Fat Joey Guest

    Default RE: Up to 2GB...


  6. #6
    Join Date
    Dec 1969

    Default I would recommend 'text'

    nText is used if you need UNICODE. If you don&#039;t, then stick with just &#039;text&#039; and you can hold even more! Same with varchar. varchar can go to 8000 chars while nvarchar can only go to 4000

Posting Permissions

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