We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Oracle 10 EE8MSWIN1250 character set export to UTF-8

chuntse
chuntse asked
on
Medium Priority
3,726 Views
Last Modified: 2013-12-19
Hello,

if Oracle database which was created with EE8MSWIN1250, is it possible to export the data as UTF-8 encoded (AL32UTF8).

If not, when data is exported it is EE8MSWIN1250 format. Can I import this into a database created with AL32UTF8 character set. If so what do I have do?

Thanks in advance.
Comment
Watch Question

Top Expert 2009
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Thanks.

Just to clarity, if I set shell environment to NLS_LANG=AMERICAN_AMERICA.AL32UTF8
Then when I export the data (which is stored in database as EE8MSWIN1250), oracle client will encoded the exported data to AL32UTF8?
Top Expert 2009

Commented:
Yes. Absolutely.

Then when you do the import, Oracle will re-translate to the destination database, if that database character set is compatible.
Top Expert 2009

Commented:
Also pay attention to the export log/output it will report which character set it is using.

Author

Commented:
Excellent! Thanks

Author

Commented:
If I have stored procedure that triggers the export of data does the NLS_LANG have an effect when the stored procedure is started from Oracle SQL developer?
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.