Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 10, 2007 at 04:55 PM

    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

    Add comment
    10|10000 characters needed characters exceeded