4 Replies Latest reply on Aug 16, 2018 4:06 PM by rp0428

    export replaces accented characters with '?'

    user7364583

      I created a procedure with accented characters in the comment:

       

      create or replace PROCEDURE LG_TESZT1 AS

      BEGIN

      -- árvíztűrő kanyarfúrógép

        NULL;

      END LG_TESZT1;

       

      Then I tried to export it (Tools | Preferences | Environment | Encoding: 8859_2; Export | Encoding: 8859_2)

      Result: and sql file, where the special accented characters are gone:

       

      --------------------------------------------------------

      --  File created - kedd-augusztus-14-2018 

      --------------------------------------------------------

      --------------------------------------------------------

      --  DDL for Procedure LG_TESZT1

      --------------------------------------------------------

      set define off;

       

        CREATE OR REPLACE EDITIONABLE PROCEDURE "ARCHIVE"."LG_TESZT1" AS

      BEGIN

      -- ?rv?zt?r? kanyarf?r?g?p

        NULL;

      END LG_TESZT1;

       

      /

       

      select * from NLS_DATABASE_PARAMETERS where PARAMETER like '%CHARACTERSET';

      NLS_NCHAR_CHARACTERSET    UTF8

      NLS_CHARACTERSET    EE8ISO8859P2

       

       

       

      When I repeat the above export in a database where the character sets are the following, then the export is correct:

       

      select * from NLS_DATABASE_PARAMETERS where PARAMETER like '%CHARACTERSET';

      NLS_NCHAR_CHARACTERSET    AL16UTF16

      NLS_CHARACTERSET    EE8ISO8859P2

       

       

      Result of export (Tools | Preferences | Environment | Encoding: 8859_2; Export | Encoding: 8859_2):

       

      --------------------------------------------------------

      --  File created - kedd-augusztus-14-2018 

      --------------------------------------------------------

      --------------------------------------------------------

      --  DDL for Procedure LG_TESZT1

      --------------------------------------------------------

      set define off;

       

        CREATE OR REPLACE PROCEDURE "ARCHIVE"."LG_TESZT1" AS

      BEGIN

      -- Árvíztűrő kanyarfúrógép

        NULL;

      END LG_TESZT1;

       

      /

       

      What should be done in the first case to obtain a correct export.sql file?

       

      P.S.:

      I used Total Commander View, with Options Hex to look at the export file.

      In this way I could examine the export file in a hex dump format.