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."
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:
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.
However, Trace Flag 4048 is still in the ASE 12.5.1 codeline.
Last edited by pdreyer; 06-23-08 at 03:53.
Reason: Rather use varchar