SAP Knowledge Base Article - Preview

3387087 - Japanese half-width Katakana characters are not convereted - SAP ASE


  • For example, ASE default character set is eucjis as below.

1> sp_helpsort
2> go


Sort Order Description

 Character Set = 140, eucjis
     Extended Unix Code for JIS-X0201 and JIS-X0208.
     Class 2 Character Set
 Sort Order = 50, bin_eucjis
     Binary sort order for Japanese using the EUC JIS character set
(return status = 0)

  • When you connect to the ASE with sjis (Shift-JIS) as a client charset and retrieve half-width (Hankaku) Katakana characters from a table, you get question marks "?" with a warning message as below instead of actual characters.

WARNING!  Some character(s) could not be converted into client's character set. Unconverted bytes were changed to question marks ('?').



  • SAP Adaptive Server Enterprise (ASE) 15.x
  • SAP Adaptive Server Enterprise (ASE) 16.0


SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0


KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

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.