Richard Kaye wrote: > 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. >
Dave Crozier wrote: > Vince, > You need to use ntext or even nvarchar(max) as ntext/nvarchar(max) stores > the Unicode character whereas tesxt will only store the ASCII character set. > It doubles the amount of data held but it works - been there, got the > teeshirt. > Thanks to both of you! That sounds promising. _______________________________________________ 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/[email protected] ** 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.

