can't see the hebrew character

[ZEHAVISHUL]

wrote the following lines in sql+ and can't see the hebrew character.

create table zz (z varchar2(5));
insert into zz values ('ABC');
insert into zz values ('אבג');

select * from zz;
Z
-----
ABC
???

what's I need to do?
Thanks zehava

[debasisdas]

Hi
ZEHABISHUL
Welcome to TSDN.

You have reached the right place for knowledge shairing.

Here you will find a vast resource of related topics and code.

Feel free to post more doubts/questions in the forum.

But before that give a try from your side and if possible try to post what/how you have approached to solve the problem.
It will help Experts in the forum in solving/underestanding your problem in a better way.

[jsmithstl]

What is your database characterset? If it's US7ASCII, it can't support those characters. If the characterset your using doesn't support those characters, oracle replaces them with and inverted ?. I would suggest using AL32UTF8 or UTF8. Also, make sure you set your NLS_LANG environment variable correctly. It should match the characterset the data you are inserting was created it. NLS_LANG tells the database what language you are sending it so it can convert the data to the characterset of the database when it's stored. It also tells the database what language you want the characters in when you select from the database. Improper use of NLS_LANG and charactersets can easily cause corruption in your database.