insert and update WE8MSWIN1252 characters with sqlplus

$ export NLS_LANG=.WE8MSWIN1252
$ sqlplus win/win @ vnlsparameters.SQL

PARAMETER            VALUE
-------------------- ----------------------------------------
NLS_CHARACTERSET     WE8MSWIN1252

$ cat karr.SQL
SET linesize 400
SET trimspool ON
COLUMN saying format a30
COLUMN dmp format a110

CREATE TABLE karr ( saying VARCHAR2( 50 ));
INSERT INTO karr ( saying ) VALUES ( 'Plus '  || UNISTR( '\00e7') || 'a change' );
SELECT saying, DUMP ( saying ) dmp FROM karr;
UPDATE karr SET saying = q'{Plus c'est la m}'  || unistr( '\00ea' ) || 'me chose';
select saying, dump ( saying ) dmp from karr;

drop table karr;

quit
$ sqlplus win/win @ karr.sql
Table created.

1 row created.

SAYING                         DMP
------------------------------ --------------------------------------------------------------------------------------------------------------
Plus ça change                 Typ=1 Len=14: 80,108,117,115,32,231,97,32,99,104,97,110,103,101

1 row updated.

SAYING                         DMP
------------------------------ --------------------------------------------------------------------------------------------------------------
Plus c'est la même chose       Typ=1 Len=24: 80,108,117,115,32,99,39,101,115,116,32,108,97,32,109,234,109,101,32,99,104,111,115,101

TABLE dropped.