Cannot read Oracle 12 NVARCHAR2 field with Lazarus 2.2.2+ZeosLib 7.2.14 on Linux

[ionsem]

Hello Everyone,

I'm using:

• Lazarus 2.2.2/FPC 3.2.2/ZeosLib 7.2.14.
• Database: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0
• Oracle Instant Client Version 21.7.0.0.0

I can successfully connect to database, make queries and execute stored procedures.
The problem is only when I'm trying to query NVARCHR2 fields (unicode), instead of unicode text I get "¿¿¿¿¿" in data controls (like TDBGrid).
ClientCodePage on ZConnection is set to AL32UTF8.
NLS_LANG=AMERICAN_AMERICA.AL32UTF8.
sqlplus can read successfully that field.
Please help.
Thanks.

[marsupilami]

Hello,

honestly I don't know what is going on. Could you please try what happens if you use Zeos 8.0 from Subversion?

Best regards,

Jan

[ionsem]

Hi Jan,

the same behavior. See here the image with Lazarus, ZConnection properties (including version), the app with result and select with sqlplus (which works):
https://drive.google.com/file/d/1pnYN_v ... sp=sharing