SQL 2000 and ASP - help!!!!

[acejj26]

I just ported all my data from an Access DB to SQL 2000 DB. Most things worked alright except now when I try to retrieve data that is more than 255 characters, it gets truncated when it didn't do so when I was retrieving data from the Access database. Does anyone know a workaround for this?? I could really use the help.

 

[RoadRuner]

sql 6.5 supports large field sizes like you need.

afterward 7.0 and up require the use of blobs, in accordance to the new ansi db standard.

sorry. go back to 6.5 or re-code your apps to use blobs.