How to change the character set in order to be able to view hebrew via ODBC

[Former Member]

Hello,

Can anyone walk me through the steps I need to take in order to change

the DB character set so I will be able to view unicode sets (hebrew) directly

via ODBC connection (Via SAP it works fine and is configured correctly)

My database is Oracle Release 9.2.0.7.0 , I am running it on Windows 2003

and my version of SAP R/3 is 4.6c

When I connect to the DB directly via ODBC connection I can't see the hebrew characters (code page 1800 in SAP)

I tried changing the NLS_LANG settings on the server registery but this did not help.

Thanks,

Mark

[markus_doehr2]

First of all read Note 581312 - Oracle database: licensing restrictions:

[...]

As of point 3, it follows that direct access to the Oracle database is only allowed for tools from the areas of system administration and monitoring. If other software is used, the following actions, among other things, are therefore forbidden at database level:

• Creating database users

• Create database objects

• Querying/changing/creating data in the database

• Using ODBC or other SAP external access methods

[...]

Are you trying this on the database server itself? If yes, then you need to install the hebrew codepages as well as hebrew fonts in order to display the data correctly.

--

Markus