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.