Graham, Text is the one to go for. http://msdn.microsoft.com/en-us/library/aa175795.aspx
"Generally speaking, you use text to store huge ASCII character strings, ntext for Unicode character strings, and image for binary image data. Worried about size? Text gives you up to 2^31 - 1 (2,147,483,647) variable-length non-Unicode characters, ntext up to 2^30 - 1 (1,073,741,823) characters, and image up to 2^31 - 1 (2,147,483,647) bytes. The actual storage size, in bytes, for ntext is two times the number of characters entered. The SQL-92 synonym for ntext is national text." Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Graham Brown Sent: 14 July 2008 14:44 To: [email protected] Subject: Upsizing memos Hi all I'm just working on an upsize using cursor adapters from dbc to SQLServer. Just realised my memos aren't working. What should memo fields be in SQL, text or ntext? I've upsized as ntext and they are all getting truncated. Thanks Graham --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ 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.
