Remove Space Padding in String Concatenation

 

This setting specifies if the space padding will be removed before applying the string concatenation operator (||). Disabling this feature allows space padding for fixed length CHAR type data to be kept before applying a string concatenation operator. Enabling this feature indicates the space padding is removed before applying the string concatenation operator. This feature is set at both the client end and server end. If this feature is not set at the client end, then the setting is the same as it is at the server end. This setting corresponds to the DB_StrOP keyword in the dmconfig.ini file. The default setting is disabled.


Related topic:

Data Manipulation