Sybase returns error An error occured converting UNICODE to the charset used by the server..

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..