Dbms output does not handle non-ascii characters correctly

[Claus Pedersen]

I have the following test script including the Danish characters æøå ÆØÅ:

BEGIN
  dbms_output.put_line ('Test æøå ÆØÅ '||ascii('æ')||' '||ascii('Æ'));
END;

In the DBMS Output tab it is shown as:

Test æøå ÆØÅ 50086 50054

 

[fabrice]

i tested and obtained : Test æøå ÆØÅ 230 198
with beta 2

 

[Marco Kalter]

Input and output look the same. Can you let me know what exactly is incorrect?

 

[Claus Pedersen]

Sorry, I did not notice that my copy-paste from PLD into this board fixed the problem

The problem is that PLD shows all the special characters in DBMS Output as a rhombus with a question mark inside. Apparently, I can not not copy/attach any screenshots here (without saving them in an url)?

But it looks like this: Test ��� ���

My version is beta 2

 

[fraenkg]

I can reproduce this ...
Pic 2409301.png show result of the select statement
Pic 2409302.png output for block

I use NLS_LANG = GERMAN_GERMANY.WE8MSWIN1252 for windows 10 client and GERMAN_GERMANY.AL32UTF8 on database

Best regards

 

[Marco Kalter]

Thanks for the clarification. For a WE8MSWIN1252 client and UTF8 database I can indeed reproduce this. We'll fix it.

 

[fraenkg]

The problem is fixed for me with Beta 3. Thank you.

 

[Claus Pedersen]

Fixed for me as well, thanks