| Change instance characterset from WE8ISO8859P15 to WE8ISO8859P1 [message #159505] |
Mon, 20 February 2006 01:22 |
puneetsachar
Messages: 97
Registered: March 2005
Location: New Delhi, India
|
Member |
|
|
Can I change my local instance characterset from WE8ISO8859P15 to WE8ISO8859P1.
Cos, when i tried this ...
SELECT * from query_description where query_description = 'La Réunion * All taxes and parafiscal charges';
if not succesfull creates an entry into this table.
Problem is : Its not able to recognize 'é' in IPDEV so query fails although the entry is present rather it
creates another record as 'La Rýunion * All taxes and parafiscal charges'.
I tried to find difference in oracle char set by running the query ,
SELECT * FROM nls_database_parameters
Only difference I could note from the result was in the parameter 'NLS_CHARACTERSET'
which shows 'WE8ISO8859P15' for local
& 'WE8ISO8859P1' for IPDEV.
Puneet...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
