Search code examples
oracle12c

ORACLE 12.2 - Invalid string conversion from CLOB fiel using JDBC THIN driver

we have ORACLE database in charset WIN1250 (EE8MSWIN1250). Until ORACLE version 12.1 was everything Ok. But now we have installed ORACLE 12.2 and same data which are read from database contains invalid characters. For example, i show screenshot from DBeaver (It is something like SQLDeveloper - but it universal and for connection to ORACLE have used same THIN driver as we) Firs two pictures are from ORACLE 12.1 (settings and data from table with CLOB field) and second two pictures are from ORACLE 12.2 (settings and same data)

Does anybody know what difference is between 12.1 and 12.2 version? I have read many documents on ORACLE website but no result.

ORACLE 12.1 SETTINGS

ORACLE 12.1 SETTINGS

Data from ORACLE 12.1 - correct characters

Data from ORACLE 12.1

ORACLE 12.2 SETTINGS

ORACLE 12.2 SETTINGS

Data from ORACLE 12.2 - contains invalid characters

Data from ORACLE 12.2

Solution

  • It is issue in ORACLE 12cR2. It is necessary to apply patch number 27002286. For my case it was "Patch 27002286: WINDOWS DB BUNDLE PATCH 12.2.0.1.171130"

    It will solve the problem.