Selecting encoding settings
Published 26 July 2017
To view the deployment script with correct formatting in Oracle SQL Developer, the encoding settings in Data Compare for Oracle and Oracle SQL Developer must be compatible.
We recommend these compatible settings:
| Data Compare for Oracle | Oracle SQL Developer |
|---|---|
| UTF-8, UTF-8 with preamble | UTF-8, UTF8 |
| UTF-16 | UTF-16, UTF16, UTF_16 |
| ASCII | ASCII, Windows-1252 |
To select an encoding setting in Data Compare for Oracle:
- On the Tools menu, click Application Options.
- Select the General tab.
- Under Deployment scripts, in the Encoding box, select the encoding setting you want to use.
To select an encoding setting in Oracle SQL Developer:
- On the Tools menu, click Preferences.
- Under Environment, in the Encoding box, select the encoding setting you want to use.
