CODEWITHSUNDEEP
c#oledbsqlplusoledbconnectionoledbcommand
GuruGada
GuruGada

Reputation: 117

Display hebrew language sqlplus

I am trying with oracle database to Insert and select Hebrew letters and it not working well.

I tried

Insert into mytable values ('היי');

and the result is ??? and not היי

can someone help me with that

Edit:

Now after i ask from DBA for hebrew option i can write in Hebrew from the sqlplus

but now from my project it still write ???

my code is 

OleDbConnection conn = Connect();
conn.Open();
OleDbCommand com = new OleDbCommand("Insert into mytable values ('היי')", conn);
com.ExecuteNonQuery();

and still the result is ???

Upvotes: 2

Views: 455

Answers (1)

pksnj
pksnj

Reputation: 56

Your database character set has to support unicode characters in order to be able to store non-ascii characters. This setting is defined by the DBA when creating the database which means your DBA most likely needs to recreate the database from scratch. This is not an easy option if the database is already in use by developers or even worse if this database is in production. The organisations generally take it on as a project.

Upvotes: 2

Related Questions