Re: Sql Server NTEXT fields

  • From: Gus Spier <gspier@xxxxxxxxxxx>
  • To: DGoulet@xxxxxxxx
  • Date: Wed, 03 May 2006 10:25:53 -0400

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
--
//www.freelists.org/webpage/oracle-l





Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2006