SQL memo datatype (SECOND TIME)

Someonehas 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

[647 byte] By [DavidDavis] at [2008-1-23]

«« VSTS Ship Date?
»» VFP8.0 Chaining Reports

# 1

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.

ChadLudwig at 2007-9-8 >