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.
--
Stephen Russell
Sr. Production Systems Programmer
CIMSgts
901.246-0159 cell
_______________________________________________
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.
