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 -> What´s wrong with sqlplus? Sign convert problem.

What´s wrong with sqlplus? Sign convert problem.

From: jochen <jochen.rittmann_at_gmail.com>
Date: Fri, 30 Nov 2007 04:04:24 -0800 (PST)
Message-ID: <ee9f5faa-a155-461f-a5a8-fbdb40d51c6c@l1g2000hsa.googlegroups.com>


We use 9.2.0.6.

We have a 'problem' to execute an update command like

update <tablename>
set expression=

'§STEP§STEP29'                                                                                                                        /
commit
/

If i logon in sqlplus and run the script with copy and paste, the sign '§' is not crrect in db record. It es converted to an unknown sign like '~'. In the command line, the sings that are visible by executing the pasted command, the § sign looks like correct.

If i run the script with sqlplus and @script.sql the § is correct in record.

Why? Where is the
problem?

Thank for help! Received on Fri Nov 30 2007 - 06:04:24 CST

Original text of this message

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