I encountered a problem using the OCIDLL variable with Oracle instant clients.
Some special characters were converted to ? Appears to be characters above asci 128.

Simple test case:

SQL: select ' SEI’s (“SEI”) ' spclchar from dual

Result: SEI?s (?SEI?)

Delphi 11.3
DOA 4.14
Oracle DB 19.19
Oracle Instant Client 19.3 64 bit. I tried Instant client 21.3. Same result.

The variable method returns the correct results when using a full oracle client install. The OracleHomeName is auto populated in this case.

Am I missing another setting using the OCIDLL method?

Last edited by CAR; 12/08/23 06:23 AM.