nvarchar columns not displayed

[Eduard]

Hi,

I suppose is some kind of misconfiguration on my oracle client but when I run something like

select nvarchar_col, to_char(nvarchar_col) from table1 where nvarchar_col like 'a%'

it returns
,'abc'
,'aij'

The nvarchar column is not displayed but the convert to varchar works fine.

Some client/server configurations:

Using
Home: ORAW17
DLL: C:\ORAW17\bin\oci.dll
OCI: Version 8.0
Oracle9i Enterprise Edition Release 9.2.0.7.0
Character size: 1 byte(s)

Registry
SOFTWARE\ORACLE\HOME0
ORACLE_GROUP_NAME = Oracle - ORAW17
ORACLE_HOME_NAME = ORAW17
ORACLE_HOME = C:\ORAW17
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
ORACLE_HOME_KEY = Software\ORACLE\HOME0
MSHELP_TOOLS = C:\ORAW17\MSHELP
SQLPATH = C:\ORAW17\dbs
OWAST = C:\ORAW17\ASSISTANTS\OWAST
OWASTDBS = OFF
OWASTHOME = OracleWebAssistant0

Database NLS parameters:
NLS_CHARACTERSET WE8ISO8859P1
NLS_NCHAR_CHARACTERSET AL16UTF16

Any ideas? Thanks in advance

 

[Marco Kalter]

This is an Oracle8 client limitation. You will need to upgrade to an Oracle9 or later client.