none
SQL memo datatype (SECOND TIME)

    Question

  • Someone has to be using memo data in SQL

    I have a simple VB.Net application that records Engineering Change Requests.  Currently I'm using varchar fields to record proposed changes.  I'm using varchar since I don't know what the datatype that is equal to the MS Access Memo datatype.

    I did look in the help files with limited success.  If I remember correctly it said that you can use the Image datatype to store large amounts of data.  When I tried to creating a select statement in VB.Net with an Image datatype field, VB said that it can't handle that datatype. Help

    Thanks

    David Davis
    Wednesday, June 08, 2005 6:44 PM

Answers

  • If it is just character data, then:

    SQL Server 2000: use the Text field type

    SQL Server 2005: use the varchar(max) field type

    Those are similar to the Memo datatype from Access.
    Wednesday, June 08, 2005 8:50 PM

All replies

  • If it is just character data, then:

    SQL Server 2000: use the Text field type

    SQL Server 2005: use the varchar(max) field type

    Those are similar to the Memo datatype from Access.
    Wednesday, June 08, 2005 8:50 PM
  • I use ntext, I believe when I used the Access Upsizer utility that is what it converted it to. I haven't heard of any problems from the developers.
    Tuesday, June 14, 2005 9:39 PM