Re: CLOBS in ora 8.1.7

Thanx. As soon as I get my CSI numbers I'll try to find it.

Meanwhile:

The tablename is xmldata, the column name (a CLOB) is info

Select dbms_lob.substr(info,100) from xmldata shows me "funny" characters. The characterset for the database is UTF8

If I use sql*plus and
set long 10000
select info from xmldata
I see the data I'm expecting to see.

Is there some "magic" set of parameters for the convert function that would show
the characters output by the dbms_lob.substr function?

When I dump the results of the select
Select dump(dbms_lob.substr(info,100) ) from xmldata I see "double length" characters, as if the underlying character set were the fixed length unicode, not utf8.

If I try Select convert( dbms_lob.substr(info,100), 'UTF8','US7ASCII') from
xmldata I see a different set of "garbage" characters.

godmann wrote:

> Hi there,
>
> Read the metalink article:61737.1 (how to manipulate large objects
> using dbms_lob) shall answer your question.
>
> Allan W. Tham
> DBA
Received on Tue Dec 11 2001 - 11:53:08 CST