Multibyte characters failing in SybaseCEP Studio Version 4.0.0

[Former Member]

Hello,

I am running SybaseCEP Studio Version 4.0.0. I have several projects that are receiving customer entered data, and then it inserts that data to a SQL server. In the event stream the Japanese character data appears as boxes, and if I copy and paste Japanese characters from the site into the project work space it pastes in as characters.

The SQL DB receives incorrect characters as well. The SQL columns are defined as nvarchar and the source that is feeding SybaseCEP appears to be passing along the Japanese characters faithfully, but SybaseCEP does not seem to be able to represent the characters correctly.

Is there a setting somewhere in SybaseCEP that I have to set in order to enable multibyte characters in the studio / windows / event stream?

[Former Member]

Hello,

It does not look like the Sybase CEP interface to remote databases via ODBC supports multibyte characters.  I found an old outstanding Coral8 bug requesting the same functionality.

Also, I know the manual input function of Sybase CEP Studio does not support multibyte:

   629160 - Studio Send Rows dialog box does not support utf8

Internally, Sybase CEP does support multibyte characters.  As a test, I have a "ReadFromCsvFileAdapterType" read Japanese data from a file and then a "WriteToCsvFileAdapterType" write data to a second file.  The data looks the same coming out as it went in.

I was able to write to a database by attaching the JDBC Output Adapter:

http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc01030.0400/doc/html/asc1252676972735...

     1.) Set your environment variables as appropriate:

     D:\CEP_R4>type sybase.bat

     set PATH=D:\CEP_R4\Sybasec8\server\bin;%PATH%

     set CLASSPATH=D:\Sybase\jConnect-7_0\classes\jconn4.jar;D:\CEP_R4\SybaseC8\server\sdk\java5\c8-sdk-java5.jar;D:\CEP_R4\SybaseC8\server\adapters\c8-adapters.jar

     set SYBASE_C8=D:\CEP_R4\SybaseC8

     2.) Create a SQL query to insert the data:

     C:\temp>type insert.sql

     insert into t1 values (?ColumnName)

     3.) Run the JDBC Output Adapter:

     C:\temp>typet c8_jdbc_output.bat

     java com.sybase.c8.adapter.JDBCOutputAdapter --queryFile=insert.sql --db-username=RAP_USER --db-password=rap_pwd --databaseURL=jdbc:sybase:Tds:server.acme.com:5000 --streamUrl=ccl://localhost:6789/Stream/Default/Database_write_test/MyOutWindow --driver=com.sybase.jdbc4.jdbc.SybDriver

[Former Member]

Thank you! This looks reasonable and I'll give it a shot soon and let you know if it works out.