Can anyone tell me the MSSQL Server 2000 equivelent of an access 'Memo' field?
Is there such a thing?
Webboy
Grumpus
4:25 pm on Nov 26, 2002 (gmt 0)
In mySQL, it's LONGTEXT or BLOB - I always use LONGTEXT as that is what gets created when you convert Access to mySQL so I'm keeping some backward compatibility in there just in case. Not sure in MS, though. Maybe that'll give you something to look at until someone comes in with a definitive answer for ya.
G.
tomasz
5:23 pm on Nov 26, 2002 (gmt 0)
I think it is ntext. I use text or ntext.
If you are using DTS data transfer wizard from Access to SQL, the field will be created as ntext field.
