Forum Stats

  • 3,771,053 Users
  • 2,253,215 Discussions
  • 7,875,717 Comments

Discussions

german umlaut not printing correctly in print invoice report

hi

in Customer standard few customers have address with german umlaut charatcer.It appears fine on customer standard form but on invoice print it is jumbled up.

Tagged:

Answers

  • User_8JFK6
    User_8JFK6 Member Posts: 1 Green Ribbon

    Eine Möglichkeit wäre:


    SELECT TRANSLATE (

    /* Umlaute ändern und '-' ersetzten durch '_' */

         REGEXP_REPLACE (

           'Jürgen-könnte übermorgen den Text ändern.',

           '([ÖÜÄöüä])',

           '\1e'),

         'ÖÜÄöüä',

         'OUAoua')

         AS new_text

     FROM DUAL;

  • Solomon Yakobson
    Solomon Yakobson Member Posts: 18,934 Red Diamond

    Most likely locale/code page isn't setup properly:

    I:\>chcp
    Active code page: 437
    
    I:\>sqlplus [email protected]
    
    SQL*Plus: Release 12.2.0.1.0 Production on Sat Nov 6 08:19:03 2021
    
    Copyright (c) 1982, 2016, Oracle.  All rights reserved.
    
    Enter password:
    Last Successful login time: Sat Nov 06 2021 08:17:48 -04:00
    
    Connected to:
    Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
    
    SQL> select * from tbl;
    
    STR
    -----------------------------------------------
    Jürgen-könnte übermorgen den Text ändern.
    
    SQL> exit
    Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
    
    I:\>chcp 65001
    Active code page: 65001
    
    I:\>sqlplus [email protected]
    
    SQL*Plus: Release 12.2.0.1.0 Production on Sat Nov 6 08:19:49 2021
    
    Copyright (c) 1982, 2016, Oracle.  All rights reserved.
    
    Enter password:
    Last Successful login time: Sat Nov 06 2021 08:19:06 -04:00
    
    Connected to:
    Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
    
    SQL> select * from tbl;
    
    STR
    -----------------------------------------------
    Jrgen-knnte bermorgen den Text ndern.
    
    SQL>
    

    As you can see not setting proper code page/locale can garble output.

    SY.