Script to convert high-bit characters into CHR(x)

From: <jsb_at_digistar.com>
Date: Thu, 22 Jul 2004 14:27:32 -0400 (EDT)
Message-ID: <Pine.GSO.4.58.0407221421520.25268@digistar.com>

I'm faced with a situation where developers are handing insert requests to me with high-bit characters, expecting to paste them into SQL*Plus and I don't like it. I would prefer that they send their requests using the CHR() function for the character instead, like the example below:

INSERT INTO author

            (author_id, first_name, last_name
            )
     VALUES (1147, 'Andr' || CHR (138) || '', 'Coueld'
            );

Instead i'm getting a request like this:

insert into AUTHOR (AUTHOR_ID,FIRST_NAME,LAST_NAME) VALUES(1147,'Andre','Coueld');

Pine doesn't allow me to paste Andre with the accent grave over the "e" so you don't see it here, but the email request I received had the character ascii value 138.

I hate this.

Does someone have a script or suggestions how to convert these requests in such a way that no high-bit ASCII characters are being pasted? As it sits now I have to use some 3rd party terminal software when these requests come up.

Thanks and regards...

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Thu Jul 22 2004 - 13:24:29 CDT