4 Replies Latest reply: Oct 29, 2012 11:23 AM by Irian RSS

    when i insert string text in hebrew i see ????????? how to fix it ?

    GoldSoft
      hi

      when i insert string text in hebrew i see ????????? how to fix it ?

      Oracle 11.2
      Oracle Developer

      thanks
        • 1. Re: when i insert string text in hebrew i see ????????? how to fix it ?
          Irian
          The first thing to check is the database encoding, it should be something capable of storing Hebrew text or a more generic Unicode encoding depending on your specific requirements.

          Either check this with your DBA, or if you have enough privileges run one of the following statements:
          SELECT VALUE$ FROM SYS.PROPS$ WHERE NAME = 'NLS_CHARACTERSET';
          SELECT * FROM NLS_DATABASE_PARAMETERS; --check the NLS_CHARACTERSET value
          If your database encoding turns out to be wrong then you need to change this and only after setting it up properly you will be able to insert text correctly, questions on this topic should go to the Database General

          General Database Discussions

          or Installation

          Database Installation

          forums, while writing there please specify your database version as a minumum.



          If the database encoding is correct then you may simply be using a wrong font in SQLDeveloper, to change this you can go to
          Tools -> Preferences -> Code Editor -> Fonts
          and set a font capable of rendering Hebrew text or a Unicode font like Arial Unicode MS (if you have the office suite you should have this font already installed).
          • 2. Re: when i insert string text in hebrew i see ????????? how to fix it ?
            Jim Smith
            Please provide your full database version and SQL Developer version.

            The issues here are whether your database is capable of storing hebrew characters and whether the client (SQL Developer in this case) is capable of displaying them.

            Can you enter hebrew characters form the keyboard in SQL Developer?
            What is the character set of the database (select * from nls_database_PARAMETERS where parameter in ('NLS_CHARACTERSET','NLS_NCHAR_CHARACTERSET') )
            What is the data type of the column you are inserting into? (e.g. varchar2,nvarchar2....)

            I really don't know much about what character sets support which languages. You may get some more help in the Globalization Support forum.
            • 3. Re: when i insert string text in hebrew i see ????????? how to fix it ?
              GoldSoft
              thanks for the help

              my oracle: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
              my sql-developer: ver. 2.1.1.64

              NLS_LANGUAGE     AMERICAN
              NLS_TERRITORY     AMERICA
              NLS_CURRENCY     $
              NLS_ISO_CURRENCY     AMERICA
              NLS_NUMERIC_CHARACTERS     .,
              NLS_CHARACTERSET     IW8MSWIN1255
              NLS_CALENDAR     GREGORIAN
              NLS_DATE_FORMAT     DD-MON-RR
              NLS_DATE_LANGUAGE     AMERICAN
              NLS_SORT     BINARY
              NLS_TIME_FORMAT     HH.MI.SSXFF AM
              NLS_TIMESTAMP_FORMAT     DD-MON-RR HH.MI.SSXFF AM
              NLS_TIME_TZ_FORMAT     HH.MI.SSXFF AM TZR
              NLS_TIMESTAMP_TZ_FORMAT     DD-MON-RR HH.MI.SSXFF AM TZR
              NLS_DUAL_CURRENCY     $
              NLS_COMP     BINARY
              NLS_LENGTH_SEMANTICS     BYTE
              NLS_NCHAR_CONV_EXCP     FALSE
              NLS_NCHAR_CHARACTERSET     AL16UTF16
              NLS_RDBMS_VERSION     11.2.0.1.0
              • 4. Re: when i insert string text in hebrew i see ????????? how to fix it ?
                Irian
                A quick google search seems to indicate your charset should support Hebrew characters:
                http://www.collation-charts.org/oracle10g/ora10g.IW8MSWIN1255.HEBREW.html
                10g docs but i guess charset names have not changed, so the problem most probably is due to the font being used, try to check the font in
                Tools -> Preferences -> Code Editor -> Fonts