CHARACTER SET WE8ISO8859P1 to display euro or pound sign
Hi,
I have an issue where our database is created with WE8ISO8859P1 character and we need to display euro sign in table output .
I searched on many forum and many Oracle notes but could not come to single solution (apart from changing character set of database) including export and import.
I have an issue where our database is created with WE8ISO8859P1 character and we need to display euro sign in table output .
I searched on many forum and many Oracle notes but could not come to single solution (apart from changing character set of database) including export and import.
# export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15
oracle@prdracair02:/u01/app/oracle/patches
# echo $NLS_LANG
AMERICAN_AMERICA.WE8ISO8859P15
oracle@prdracair02:/u01/app/oracle/patches
# imp \"/ as sysdba\" FILE=stage.xxproduct_stg.dmp FROMUSER=stage touser=CHAREXPORT log=stage.log
Import: Release 10.2.0.4.0 - Production on Wed Apr 17 22:18:56 2013
0