Re: What´s wrong with sqlplus? Sign convert problem.

On Nov 30, 6:04 am, jochen <jochen.rittm..._at_gmail.com> wrote:
> 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!

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 Received on Fri Nov 30 2007 - 08:37:18 CST