text or ntext Marius ----- Original Message ----- From: "Coleman, Brian" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, October 29, 2004 4:12 PM Subject: access memo to sql
> I'm not sure what to do on this one. I have an access database populated > with data that has 5-6 memo fields. I'm trying to move the database to > SQL 2k and I'm having a problem with the memo field. At first I thought > I would just make it a varchar but they have limits of 8000 characters > and when I try to import it's telling me there records (I don't know how > many) that are over the size limit. Is there an SQL data type that will > take large strings like memo fields? > > Thanks, > Brian > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182985 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54