如何使用经典ASP页面从Oracle数据库读取NCLOB，CLOB数据值？ [英] How to read NCLOB, CLOB data values from Oracle database using Classic ASP pages?

问题描述

我遇到以下错误：
Microsoft的Microsoft OLE DB Provider for Oracle：不支持数据类型。

I am getting the following error: Microsoft OLE DB Provider for Oracle: Data type is not supported.

有人可以帮我解决这个问题吗？ ...

Could somebody help me figure out this please...

情况：
最近将数据库从SQL Server 2005迁移到Oracle 11g。该表之一包含SQL Server中ntext数据类型的某些列，这些列在迁移到Oracle时已转换为NCLOB。客户端是经典的ASP页面（VBScript），可通过OLEDB连接访问Oracle数据库。
当执行到达查询（选择查询）时，该查询读取了NCLOB类型的列时，它将引发 Microsoft OLE DB Provider for Oracle：不支持数据类型错误。当我取出该特定列时，查询运行良好...

Situation: Recently migrated database from SQL Server 2005 to Oracle 11g. One of the table has some columns of the data type ntext in SQL Server, which were converted to NCLOB during migration to Oracle. Client is Classic ASP page (VBScript) accessing the Oracle Database through OLEDB connection. When the execution reaches the query (Select query) that reads the column of type NCLOB it is throwing the Microsoft OLE DB Provider for Oracle: Data type is not supported error. When I take out that particular column then the query is running fine...

问题：如何从Classic ASP页面读取NCLOB，CLOB数据值？

QUESTION: How to read NCLOB, CLOB data values from Classic ASP pages?

请告诉我是否需要更多信息.....

Plz let me know if you need more information.....

谢谢..

推荐答案

我知道Microsoft的Oracle ODBC驱动程序不支持任何LOB类型-我打赌它的OLE DB提供程序也不支持给定错误。可以升级到Oracle OLE DB提供程序吗？

I know that Microsoft's ODBC Driver for Oracle didn't support any of the LOB types-- I would wager that its OLE DB Provider didn't either given the error. Can you upgrade to the Oracle OLE DB Provider?

此外，由于要从SQL Server迁移到Oracle，您是否真的需要使用NCLOB数据类型？由于Oracle允许数据库字符集为Unicode，因此通常不需要（也不想）使用NVARCHAR2或NCLOB数据类型，除非您坚持支持需要非Unicode字符集的旧数据库。对于本质上是英语或西方欧洲人的数据，将数据存储在CLOB中具有很大的存储空间优势，因为CLOB会将数据存储在UTF-8中而不是NCLOB中的UTF-16中（假设您选择了Unicode）数据库的字符集）。消除NVARCHAR2和NCLOB列也往往使前端工具更容易处理数据。

As an aside, since you are migrating from SQL Server to Oracle, do you really need to use the NCLOB data type? Since Oracle allows the database character set to be Unicode, you normally don't need (and don't want) to use the NVARCHAR2 or NCLOB data types unless you're stuck supporting an old database that requires a non-Unicode character set. For data that is English or Western Eurpoean in nature, storing data in a CLOB has substantial benefits in terms of storage space since the CLOB would store the data in UTF-8 rather than UTF-16 in an NCLOB (assuming that you picked a Unicode character set for the database). Eliminating the NVARCHAR2 and NCLOB columns also tends to make it much easier for front-end tools to handle the data.

这篇关于如何使用经典ASP页面从Oracle数据库读取NCLOB，CLOB数据值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！