Re: How to replace non-ascii control characters stored in CLOB field of Oracle 9i Database?
_.-In alt.ascii-art, gan...@gmail.com wrote the following -._ > 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. <snip> > 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? Part of asking questions the smart way[0] is to ask them in the right place. While everyone here has ASCII experience I am sure that very few have experience with Oracle 9i. I would recommend asking this question on an Oracle mailing list or a database newsgroup where people have no doubt encountered and solved your issue before. [0] http://www.catb.org/~esr/faqs/smart-questions.html -- .-')) fauxascii.com ('-. | It's a damn poor mind that ' ..- .:" ) ( ":. -.. ' | can only think of one way to ((,,_;'.;' UIN=66618055 ';. ';_,,)) | spell a word. ((_.YIM=Faux_Pseudo :._)) | - Andrew Jackson
Original message headers
X-Google-Thread: f996b,f680fd0b8bb12909 X-Google-Attributes: gidf996b,public X-Google-Language: ENGLISH,ASCII-7-bit Path: g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!peer01.cox.net!cox.net!p01!dukeread10.POSTED!53ab2750!not-for-mail Newsgroups: alt.ascii-art From: Faux_Pseudo <Fau...@gmail.com> Subject: Re: How to replace non-ascii control characters stored in CLOB field of Oracle 9i Database? References: <114...@u72g2000cwu.googlegroups.com> Reply-To: f0s...@gmail.com User-Agent: slrn/0.9.8.0 (Linux) Lines: 21 Message-ID: <6nDYf.22081$C85.16220@dukeread10> Date: Tue, 04 Apr 2006 23:33:22 GMT NNTP-Posting-Host: 70.160.232.12 X-Complaints-To: abu...@cox.net X-Trace: dukeread10 1144193602 70.160.232.12 (Tue, 04 Apr 2006 19:33:22 EDT) NNTP-Posting-Date: Tue, 04 Apr 2006 19:33:22 EDT Organization: Cox Communications Xref: g2news1.google.com alt.ascii-art:1286
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.