This content has been marked as final. Show 4 replies
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';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
SELECT * FROM NLS_DATABASE_PARAMETERS; --check the NLS_CHARACTERSET value
General Database Discussions
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 -> Fontsand 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).
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.
thanks for the help
my oracle: Oracle Database 11g Enterprise Edition Release 18.104.22.168.0 - Production
my sql-developer: ver. 22.214.171.124
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
A quick google search seems to indicate your charset should support Hebrew characters:
Tools -> Preferences -> Code Editor -> Fonts