oracle-databasesqlplus

In sqlplus how to change or specific file encoding to utf8

in sql plus I created a file :

>EDIT test.sql

the file encoding is ansi. I want to change it to ut8, I tried by save-as but it didnt work

how to change test.sql from ansi to utf8 in sql plus ?

Solution

  • If you want to change your default editor for sqlplus, you can do this:

    1. logon to sqlplus

    2. use "define" command to set the path to the new editor. I like TextPad (which handles utf8 automatically), so the command (for my machine anyway) would be:

      define _editor="c:\Program Files\TextPad 7\TextPad.exe";

    3. Now, the edit command will bring up the new editor.

    For TextPad, you can change the encoding by doing the following:

    Conversion: Conversion between various file formats and encodings can be made using the Save As command on the File menu. The options for encoding are ANSI, DOS, Unicode, Unicode (big endian) and UTF-8.

    So after doing the steps above, edit will bring up Textpad, and using Save As you can save the file using various encodings.

    This is one benefit of changing the default editor from Notepad.