???? when writing Hebrew Chars to Oracle (ODAC)

[RoniLev]

Hi there
I wrok on Win7 64bit machine.
Delphi X2 + ODAC + Oracle Client 11g.
my NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 (in registry)
I am trying to insert record to Oracle 11g database
using the save charaterset AMERICAN_AMERICA.WE8ISO8859P1.
but i get ????? inted of Hebrew chars.
I tried setup everything i can without success.
Any ideas?
Thanks

[MaximG]

To work correctly with Hebrew characters used in query parameters, please use the UseUnicode property: https://www.devart.com/odac/docs/?devar ... nicode.htm If you are using Hebrew characters in the query text, then in addition to UseUnicode use the UnicodeEnvironment property: OraSession.Options.UnicodeEnvironment := True;

[RoniLev]

Hi Maxim
i set
Options.UseUnicode = True
Options.UnicodeEnvironment = True

but its not working . i still get ??? insted of Hebrew chars.
i want to remaind you that my Oracle charset is WE8ISO8859P1.
it is not a Unicode Charset !!!!!!!
By the way.
BDE Tquery + DevArt Oracel ODBC write Hebrew Chars with no problem.
(with out setting it to Unicode).
So there is adiffrent in handling Hebrew chars i a non unicode Oracle charsert.
Thanks
Roni

[lior]

P1 is non hebrew charset. You can use it for hebrew if both the client and the database charsaet are P1.
In that case Oracle passes the char without trying to convert it.
But even then tools like Toad will show garbage.
For non unicode database you shold use Hebrew charset such as IW8ISO8859P8 (Ansi) or IW8MSWIN1255 (Windows).

[RoniLev]

Hi lior
Thanks for your reply
it works fine today with Oracle 11g using WE8ISO8859P1 Charset 32 bit clients pc.
When we moved to 64 bit clients Pc we can not see Hebrew chars.
ODAC - is reading Heabrew ok but when writing with it i see ????
Devart ODBC - Read and write Hebrew (but we prefer to work with Delphi/Devasrt components)
Delphi XE2 BDE+TQUERY can not readqwrite hebrew from this Oracle.
Any ideas?
Roni

[MaximG]

The WE8ISO8859P1 encoding has no support for Hebrew charset. Try to conduct a little test. Write Hebrew data in a table using Devart ODBC Driver for Oracle. To read such data, use SQL Plus. Let us know whether you get correct display of Hebrew characters on reading with SQL Plus.