Unable to Display Unicode Characters

[near]

I am unable to display any Unicode Character in the new PSD 7.1 release in any of the window types -- SQL Window, Program Window etc. (You may need to read this post by setting the browser encoding as "Unicode (UTF-8)".)

In the code below, I have inserted a Euro sign in "dbms_output.put_line('

 

[Rob Milne]

Try this. It works for me.

-- SQL Window
select unistr('\20AC') from dual;

-- Command Window
exec dbms_output.put_line( unistr('\20AC'));

 

[Marco Kalter]

The character set on the server is WE8ISO8859P1, and WE8MSWIN1252 on the client, so everything will be converted between these 2 character sets by default. As a result, the euro sign is "lost". Only nvarchar2 and nchar will be displayed as unicode, since the national character set is AL16UTF16.

If you want to do Unicode developlent, it may be a good idea to create a UTF-8 database.