Sybase returns error An error occured converting UNICODE to the charset used by the server..
book
Article ID: KB0086578
calendar_today
Updated On:
Products
Versions
TIBCO DataSynapse GridServer
-
Not Applicable
-
Description
Resolution: When running a Manager with an external Sybase database, the following error may occur:
java.sql.SQLException: while creating new connection to :jdbc:sybase:Tds:machine.example.com:5000/datagrid, JZ006: Caught IOException: java.io.IOException: JZ0I6: An error occured converting UNICODE to the charset used by the server. Error message: java.io.CharConversionException: java.io.UnsupportedEncodingException: hp-roman8
This error occurs because there is a mismatch between the default client side and the default server side character sets. The problem can be addressed by changing the character set converter on the client or by adding the appropriate character set on the server. For example, add ?charset=iso_1 last in the database URL.
Issue/Introduction
Sybase returns error An error occured converting UNICODE to the charset used by the server..