Skip to Main Content
  • Questions
  • Need to print latin ä charater through Dbms out into apex sql developer ?

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, jay.

Asked: October 29, 2017 - 8:18 am UTC

Last updated: October 31, 2017 - 1:58 am UTC

Version: 12 c

Viewed 1000+ times

You Asked

Hi gurus,

I am trying to print this character ä through apex sql developer but it return me ? instead of this ä , any one know how can I achieve this.
begin
dbms_output.put_line (' http://fäm.co/' ) ;
end;

if my question is not clear please click on image link. thanks in advance

https://community.oracle.com/servlet/JiveServlet/showImage/2-14577817-448917/pastedImage_11.png

and Connor said...

You are bound by the characterset settings of the database. For example, on my local Apex installation

APEX_CHARSET

where my database characterset support UTF8.

SQL> select * from V$NLS_PARAMETERS
  2  where parameter = 'NLS_CHARACTERSET';

PARAMETER                                                        VALUE
---------------------------------------------------------------- ------------------------------
NLS_CHARACTERSET                                                 AL32UTF8


So check with your DBA to ensure that your database characterset is set appropriately, and then your "client" (ie, the means via which you are using Apex - weblogic, ords, embedded gateway etc) also is appropriately set.

Is this answer out of date? If it is, please let us know via a Comment

More to Explore

APEX

Keep your APEX skills fresh by attending their regular Office Hours sessions.