Powerbuilder 11.5, Oracle DB 12, NVARCHAR2 not recognized or working

1
0
-1

Hi

I want to access NVARCHAR2 fields in my Oracle DB 12.1.0.2.0 from a Powerbuilder 11.5 Application.

DB-Params:

NLS_NCHAR_CHARACTERSET = AL16UTF16

NLS_CHARACTERSET = WE8MSWIN1252

No NLS_ Registry entries

Powerbuilder:

NLS Charset = Unicode

​The Oracle Instant Client DLLs Version 12 (I tried 11 also) are located in the workspace directory.

 

When accessing the table via Database Painter I get the error message ORA-04043: Object NVARCHAR2 not found.

Unicode content is displayed in a datawindow with reversed ???

Writing unicode content via the datawindow effectively writes ??? into the DB

 

Where do I go from here?

 

 

 

 

Question Tags: 

Answers

Chris Pollach answered Powerbuilder 11.5, Oracle DB 12, NVARCHAR2 not recognized or working

1
0
-1

Hi Jörg;

    Support for Oracle 12.x was not available in PowerBuilder until version 12.6 and in fact ... you needed a few EBF's into that release to get it right.

My suggestion would be to migrate to PB 2017 coming out at the end of June to get the proper O12C support you need.

HTH

Regards ... Chris

joerg-walter@gmx.de's picture

Thanks for the answer, Chris!

I guess we will migrate to the next version.

I tried and partially succeeded:

 

I am using the Oracle Client 11.2 (with a 12.1 DB)

I modified my connection string and I am now able to

update and select unicode columns from within script (NVARCHAR2),

update unicode columns from a datawindow,

display the selected content in a MessageBox.

My DBParm is:

http://imgur.com/a/4Jkd2

​The field is set to the Tahoma font

The Charset Property is thaicharset! (cannot change this)

 

But Unicode content is not correctly displayed in datawindow fields (still upside down ???)

Screenshot:

http://imgur.com/a/fDIss

What might be wrong?