Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> sqlplus command translate
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