Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Change Data from "US7ASCII "to "WE8MSWIN1252" without changing the NLS_CHARACTERSET

8bb91c24-b15d-46f9-8f18-4ca6e0aab0beNov 13 2015 — edited Nov 16 2015

We are using Oracle Database and our NLS_CHARACTERSET is set as "US7ASCII" . We are downloading data from other source and it is getting stored as below in our database table.

Our database data ("US7ASCII")

test.jpg

Our client database NLS_CHARACTERSET is set as "WE8MSWIN1252" and he wants data as below. Can we convert our table data to "WE8MSWIN1252" format using any function in oracle like "CONVERT(column_name,'US7ASCII','WE8MSWIN1252')" which is not working in this case or any other solution ? we cant change database nls_characterset since it might result in data loss so we are looking for some other solution. Thanks.

what user wants ("WE8MSWIN1252") :

test.jpg
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 11 2015
Added on Nov 13 2015
#database-key-features, #globalization-support
5 comments
3,969 views