Re: Using LOB or CLOB datatype with ASP

From: Tom McClelland <tom.mcclelland_at_mondas.com>
Date: 8 Feb 2002 03:48:09 -0800
Message-ID: <cb748650.0202080348.60a4a79e@posting.google.com>

C Chang <cschang_at_maxinter.net> wrote in message news:<3C635EB2.6641_at_maxinter.net>...
> I am going to design a table including LOB or CLOB data. My WEB appl
> is designed with ASP code. Does the MS ODBC or OLEDB driver can handle
> such datatype? Thanks
>
> C Chang

The ODBC driver does, but make sure that none of your LOB/CLOB have names such as "COMMENT" which are Oracle reserved words. These do not work even if you quote them (certainly parameterised inserts don't), because the internal driver mechanism for CLOB does not quote them even if you do. (As far as I can make out)

Regards

Tom Received on Fri Feb 08 2002 - 05:48:09 CST