If you don't want SQL Server to translate your non-ASCII chars, which in the case of storing binary files would be true, you'll definitely want to use ntext.
Richard Kaye --------------------------------------------------------- This message has been checked for viruses before sending. --------------------------------------------------------- OK, just starting my homework, and according to the SQL docs, TEXT, NTEXT, and IMAGE *are* BLOBs (Binary Large Object Blocks) So I possibly have the correct column type (need to look into NTEXT more), but there may be a different way to store/retrieve the data. :-( _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/df1eef11e586a64fb54a97f22a8bd0440514495...@ackbwddqh1.artfact.local ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
