My Oracle Support Banner

Incorrect Values from ResultSetMetaData.getPrecision when Connecting to a Database 19c with a Multi-byte Character Set. (Doc ID 2750744.1)

Last updated on MARCH 11, 2022

Applies to:

JDBC - Version 19.7 and later
Information in this document applies to any platform.


A JDBC application uses the ResultSetMetaData.getPrecision on a column that is based on the type VARCHAR2(1016 BYTE).

When the application was connecting to a database 12.2, the getPrecision reported the expected value 1016 .

After the database was upgraded to 19c, the same JDBC application and JDBC driver report the value 4000.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.