YES! YES! YES! ;-)
Norman Dunbar <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <[email protected]> |
I've got Toad back again, I have found a way around our work firewalls
that allows me to ssh tunnel from my laptop to the databases. I've been
without Toad abilities for a year now, and I've hated having to use
SQL*Plus for all that time. No more!
And now a question.
I am looking at a CLOB in an 11203 database with Toad 11.0.0.116 (I'll
upgrade soon, I promise!) and I see in the hex tab of the pop-up editor,
cr/lf end of lines. However, when I select a dump of a substring of the
same CLOB actually on the database, in <spit> SQL*Plus, I only see the
lf characters.
In my options I have the following set:
Oracle/General - Unix Style checked for "Newline format for character data"
Files/General - Save files in Unix format.
In Toad, when I dump the CLOB in MOE using a DBMS_LOB.SUBSTR() call, I
see the last half dozen characters as:
61,74,61,3e,0a,00 Which = 'ata>' lf ? (where ? = a binary zero that
shouldn't be there but is!)
On the server, I get exactly the same. Note Unix style line ends.
In the popup editor, hex tab, I get the following at the end:
61 74 61 3E OD OA OO Which = 'ata>' cr lf ?
Hmm, just found something. I edited the text to remove the unwanted and
illegal (XML) binary zero at the end. When I saved it back to the table,
it shows me "Unix style newlines (LF)" on the pop-up editor status line
and on the hex tab, all the line ends are now still in Microsoft style,
except the final one, which is in Unix style. Ulp!
Confused? Me? You bet!
--
Cheers,
Norm. [TeamT]
------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)
<*> To change settings via email:
[email protected]
[email protected]
<*> To unsubscribe from this group, send an email to:
[email protected]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/