SAP Knowledge Base Article - Preview

3204101 - Data is not displayed properly on a column - SAP ASE

Symptom

When selecting data from a column of data - it does not display correctly:

  • Example 1:
    select top 5  any_data from mytest
    go
    any_data
    ---------------
           16
           16
           16
           16
           16
    (5 rows affected)
  • Example 2:
    select top 5 1,  any_data from mytest
    go

    Conversion_Date
    ----------- ---------------
               1 20220516
               1 20220516
               1 20220516
               1 20220516
               1 20220516
    (5 rows affected)

  • Example 3:
  • select top 5 any_data ,'test' from mytest
    go

    Conversion_Date
    --------------- ----
           test
           test
           test
           test
           test
    (5 rows affected)


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

"control characters" cntrl-characters cntrl special invisible  , 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.