[yark1999]

Hi,

I want to know the detail of traceflag 4048, anyone knows pls show it.

ths.

[pdreyer]

Quote from
http://www.isug.com/Sybase_FAQ/ASE/S...4/Q10.4.9.html

Release 11.0.3.2 fixes include:

CR Description

137849 Add boot time trace flag 4048 to revert to 2-digit year in the error log.

[yark1999]

hi, pdreyer,

thanks a lot.
I want to know traceflag 4048 in ASE 12.5.

In some document, I found the followings,
"There is a documented change starting with ASE 11.5 where we no longer truncate trailing spaces for CHAR datatypes in string functions.
Trace flag # 4048 Revert trailing space and variable function behavior to pre-11.5 version."


Do you konw any more detail about it ?

[pdreyer]

Indeed; This is a documented change with ASE 11.5 onwards where the behavior of many of the string functions is different because of a rewrite to conform with ANSII standards. See
What's New in Sybase(R) Adaptive Server(TM) Enterprise? (Document ID: 36440-01-1150)
Chapter 2 System Changes in Adaptive Server Release 11.5
Trailing Spaces of char Data No Longer Truncated in String Functions

The following example demonstrates this change in behavior:

select 'x'+upper(convert(char(5),'abc'))+'x'

Pre-11.5 releases produced a char(5): "xABCx". 
Adaptive Server produces a char(7): "xABC  x". 

Boot up ASE with traceflag 4048 which revert trailing space and datalength function behavior to that of pre-11.5.
Not suggested as this traceflag may be removed in the future release.
use varchar instead e.g.

select 'x'+upper(convert(varchar(5),'abc'))+'x'

However, Trace Flag 4048 is still in the ASE 12.5.1 codeline.