Zeoslib Portal

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.

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

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