How to replace non-ascii control characters stored in CLOB field of Oracle 9i Database?
I have 250 MB of data stored in the CLOB field of a database table in Oracle 9i database. This database is created with AL32UTF8 character set encoding scheme. The data inside CLOB contains approx. 14000 lines. We are reading the CLOB data in a variable and extracting every line from the data and applying substr function on the line to extract some data. The data in the CLOB contains some non-ascii control characters due to which substr function is giving problems and throwing an exception. Is there any way to replace all the non-ascii control characters from the CLOB data or from a line of the data stored in that field?
Original message headers
X-Google-Thread: f996b,f680fd0b8bb12909,start X-Google-Attributes: gidf996b,public X-Google-Language: ENGLISH,ASCII-7-bit Path: g2news1.google.com!postnews.google.com!u72g2000cwu.googlegroups.com!not-for-mail From: gan...@gmail.com Newsgroups: alt.ascii-art Subject: How to replace non-ascii control characters stored in CLOB field of Oracle 9i Database? Date: 4 Apr 2006 13:12:29 -0700 Organization: http://groups.google.com Lines: 14 Message-ID: <114...@u72g2000cwu.googlegroups.com> NNTP-Posting-Host: 65.173.228.59 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1144181559 29369 127.0.0.1 (4 Apr 2006 20:12:39 GMT) X-Complaints-To: gro...@google.com NNTP-Posting-Date: Tue, 4 Apr 2006 20:12:39 +0000 (UTC) User-Agent: G2/0.2 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; ABN AMRO),gzip(gfe),gzip(gfe) Complaints-To: gro...@google.com Injection-Info: u72g2000cwu.googlegroups.com; posting-host=65.173.228.59; posting-account=D0RWDQ0AAACL540TD93YKMwL5l_IskM_ Xref: g2news1.google.com alt.ascii-art:1283
Related ASCII art in the Gallery
Explore these categories from our collection of 11,000+ artworks:
Make your own ASCII art
Turn images, text or 3D into ASCII, or draw your own – right in your browser.
About this message.
This message was posted publicly to the newsgroup
alt.ascii-art
in 2006 and is mirrored here unchanged as part of the Historic Archives – only email addresses are masked.
The artwork and text belong to their original authors: if you copy a piece, keep the artist's initials or signature intact and credit them where you can.
Are you the author? Contact us to get your posts attributed, connected to your artist profile, or removed.
Report this message
Help us keep the archive clean and accurate. Reports are reviewed by a person – nothing is changed automatically.