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!

On Nov 30, 6:04 am, jochen <jochen.rittm... (AT) gmail (DOT) com> wrote:
With copy and paste, as you're converting that character to whatever
the local O/S decides it should be, and that hex representation may
not match the hex value found in the script for that same character.


David Fitzjarrell