8 Replies Latest reply: Aug 5, 2012 8:34 AM by Sergiusz Wolicki-Oracle RSS

    Nvarchar Does not show value

    Harry
      Fyi

      I have Oracle 11g.
      In my database one table look like.

      font -- Table Name
      ID -- number Primary Key,
      Book_Name nvarchar2(100)

      when i fire insert command on that
      insert into font values (font_seq.nextval,'સ્વાગત');commit;

      the insert charter is gujarati and insert data correctly.
      when i check using

      SQL > select BOOK_NAME From font;
      Book_NAME
      ---------------------------------
      ■■■■■■

      How can i display my guajrati data from database ?

      How to use NLS_LANG in Oracle?

      Help me out