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
goConversion_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.
SAP Knowledge Base Article - Preview