Problem with Oracle 12c vs Oracle 19c

[mjz1000]

Hey,
I use a Oracle 12 c Table with varchar2(75) Fields. The DOA Oracle DataSet declare this Field as a TStringField.
The same Table on Oracle 19c Server the DOA Oracle DataSet declare this Field as a TWideStringField.
I develop with Delphi 10.4.1 Enterprise and I don't know how I could create only one programm which support
the different declaration from both Oracle Server.
On my job the programm works with Oracle 12c, at home it has to work with Oracle 19c.

Could you help me ?

Greetings
Jörg

 

[Marco Kalter]

Perhaps the databases are created with different character sets? If the 12c database is created with an Ansi character set, and the 19c database is created with a Unciode character set, you will get this behavior.

 

[RezaM]

Hey,
we use PLSQL-Developer Version 14.0.1.1965 in our company. We upgradet the oracle server to 19c (12.2.0.3) . Are there known any issues with call prcedure with parameter as Array

 

[Marco Kalter]

Can you post your question in the PL/SQL Developer forum?