Selecting encoding settings
Published 24 February 2022
To view the deployment script with correct formatting in Oracle SQL Developer, the encoding settings in Schema Compare for Oracle and Oracle SQL Developer must be compatible.
The following is a recommended list of compatible settings:
| Schema 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 Schema 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.
Please note this option only applies when deploying to a database, not a scripts folder.
