Thaks Steve I'll try this Rafael
El 02/06/2010 01:40 p.m., Stephen Russell escribió: > On Wed, Jun 2, 2010 at 11:35 AM, Richard Kaye<[email protected]> wrote: > >> Does SQL 2008 Express support the ntext data type? That's a binary datatype >> and SQL won't try to do any character translation on a binary datatype, >> iirc. When you save the doc file to a memvar, it contains non-ascii values >> that you need to preserve. The next problem may be that you probably have >> single quotes embedded in the binary data which will throw off the parsing >> of the insert/update statement. >> > ------------------- > > USE [tester] > GO > > /****** Object: Table [dbo].[BlobDataTypes] Script Date: > 06/02/2010 11:39:28 ******/ > SET ANSI_NULLS ON > GO > > SET QUOTED_IDENTIFIER ON > GO > > SET ANSI_PADDING ON > GO > > CREATE TABLE [dbo].[BlobDataTypes]( > [ID] [uniqueidentifier] NULL, > [BlobData1] [ntext] NULL, > [BlobData2] [nvarchar](max) NULL, > [BlobData3] [varbinary](max) NULL > ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] > > GO > > SET ANSI_PADDING OFF > GO > > -------------------- > > Any of these will store office files or images, video, etc. > > > > > _______________________________________________ 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.
