Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Sql Server NTEXT fields

Re: Sql Server NTEXT fields

From: Gus Spier <gspier_at_chiliad.com>
Date: Wed, 03 May 2006 10:25:53 -0400
Message-ID: <4458BD71.8040200@chiliad.com>


Dick,

Can you get hold of an INSO filter?

I am moderately persuaded that will do the trick, but I haven't tried it myself at all.

r,

Gus

Goulet, Dick wrote:

>Folks,
>
> I've got a copy of Oracle's Gateway to Sql Server so that we can
>integrate data from a third party, mom & pop created application with
>other data stored in Oracle. This application has a number of NTEXT
>fields where comments and the like are being stored, but in Rich Text
>Format. Now from the manual:
>
> You cannot use SQL*Plus to select data from a column defined as
>Microsoft SQL
> Server data type IMAGE, TEXT or NTEXT when the data is greater
>than 80
> characters in length.
>
>Anybody know how to strip the rtf stuff out especially from the
>Microsoft side??
>
>Dick Goulet
>Senior Oracle DBA
>Oracle Certified DBA
>--
>http://www.freelists.org/webpage/oracle-l
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 03 2006 - 09:25:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US