This discussion is archived
4 Replies Latest reply: Oct 29, 2012 9:23 AM by Irian RSS

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

GoldSoft Newbie
Currently Being Moderated
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 Pro
    Currently Being Moderated
    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 Questions

    or Installation

    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points