Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> sqlplus command translate

sqlplus command translate

From: Hans J. Heerwig <hans_at_heerwig.com>
Date: Wed, 6 Oct 2004 16:56:31 +0200
Message-ID: <ck10p7$4jb$00$1@news.t-online.com>


Hi, who can help us?

(Linux SuDE sel8, oracle 9i 9.2.0.5.0)

syntax:

translate(datafield,'abcdef','uvwxyz');

We want to exchange the abcdef characters 1 to 1 into uvwxyz characters. The function worked well when the target characters has a dec value below 127.
When the target characters value is mor than dec 127, the translation produces characters with dec 191 (all, characters, even they should be different).

It seems to be somethin in the enviorement (7 bit / 8 bit)???

Who has an idea?

Many thanks in advance,

Hans Received on Wed Oct 06 2004 - 09:56:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US