3653334 - Unreadable Japanese Characters correctly in jsout_text Column of js_output Table with isql

Symptom

When connecting to the ASE server from a Windows command prompt and executing a SELECT statement on the js_output table in the sybmgmtdb database, Japanese characters in the jsout_text column appear garbled and are not displayed correctly.
A similar issue is observed in the MSG column of the DBH_MSG_LOG table in the saptools database.

isql -Usapsa -S${SAPSYSTEMNAME} -X -w10240 -Jutf8

1> use sybmgmtdb
2> go
1> select * from js_output order by jsout_exid
2> go
jsout_exid jsout_type jsout_size jsout_seqno jsout_text
----------- ----------- ----------- ----------- -----------------------------------------------------------------------------
2 0 900 0 繝・・繧ｿ繝吶・繧ｹ繧ｳ繝ｳ繝・く繧ｹ繝医′ 'master' 縺ｫ螟画峩縺輔ｌ縺ｾ縺励◆縲・
(return status = 0)

If you execute a SELECT statement using the -o parameter to output the result to a file as shown below, it will be displayed correctly.

isql -Usapsa -S${SAPSYSTEMNAME} -X -w10240 -Jutf8 -ijsdiag_1.sql -ojs_diag_1.out -e

js_diag_1.out
------------
jsout_exid jsout_type jsout_size jsout_seqno jsout_text
----------- ----------- ----------- ----------- -----------------------------------------------------------------------------
2 0 900 0 データベースコンテキストが 'master' に変更されました。
(return status = 0)

KBA 1835880 - How to diagnose issues with ASE Job Scheduler, ATM, or Scheduled Jobs - SAP ASE for Business Suite

Environment

ASE 16.1 (LANG : Japanese , Charset : sjis)
Windows Server (Japanese OS)
Administration and Management Console (AMC)

Product

SAP Adaptive Server Enterprise 16.1

Keywords

character, char, char set, incorrect, show, see, , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.