Using isql with NLS_LANG set to .UTF returns two values 170,144 for the hebrew letter 'א' instead of one value 224.
While sqlplus does return the correct "one" value 224 when using NLS_LANG is .UTF.
No matter which NLS_LANG for isql the query select dump('א') from dual always returns 170,144.
We are not using unicode. The Oracle server NLS_LANG is IW8ISO8859P8.
In odbc.ini the Charset is set to .UTF-8.
I would appreciate any ideas.
Thanks,
Morton