SQL Memo Fields??

Results 1 to 2 of 2

Thread: SQL Memo Fields??

  1. #1
    Nick Eales Guest

    Default SQL Memo Fields??

    I am trying to find the equivelant of an Access memo field in SQL. I have tried the NVARCHAR type with 4000 characters max but when I insert a string above 4000 characters it gives me an error about not being able to truncate the data.<BR><BR>Is there such a thing in SQL whereby the size of the string which you can put into the field is unlimited in size?

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL Memo Fields??

    Scrap the &#039;n&#039; prefix anything unless you need Unicode stuff. &#039;varchar&#039; can go up to 8000. &#039;text&#039; is the one you&#039;re looking for however. This will allow I believe 2 billion characters or some extremely large amount.

Posting Permissions

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