Re: JDBC output coming out as hex

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 27 Jan 2003 22:19:17 -0800
Message-ID: <92eeeff0.0301272219.316e1662@posting.google.com>

postmaster_at_cjc.org (Cheng-Jih Chen) wrote in message news:<v3b062klb8601a_at_news.supernews.com>...
> The server is running 9.2.0.2 on Windows, and we're connecting using
> the JDBC thin client. The problem we're seeing is that SELECT output
> from JDBC is coming out as hex; accessing the same data using SQLPlus
> returns as regular characters.
>
> The same JDBC connecting to a 9.2.0.2 server on Solaris returns the
> data correctly.
>
> NLS settings between the two servers are identical.
>
> Does anyone have any suggestions? Thanks.

Are you seeing this behavior from the same client connecting to both databases on Sun and Windows? What is the server characterset?

When using thin/oci jdbc drivers, make sure you have this file in your classpath for full NLS conversion,
[ORACLE_HOME]\jdbc\lib\nls_charset11.jar for jdk/jre 1.1 [ORACLE_HOME]\jdbc\lib\nls_charset12.jar for jdk/jre 1.2, 1.3 or 1.4

Check Regional settings of your client. Unlike jdbc OCI driver and Sqlplus, thin jdbc driver does not have access to NLS settings in the registry. Instead, it reads Regional settings.

Look at section "Known Problems/Limitations In This Release" in Readme.txt located under ORACLE_HOME\jdbc.

Regards
/Rauf Sarwar Received on Tue Jan 28 2003 - 00:19:17 CST