Remove Space Padding in CHAR Output

 

This setting specifies whether the space padding for CHAR type data is removed or not. Space padding for CHAR type data in a result set is kept when this feature is disabled. The space padding for all CHAR type data is removed before copying it to the user buffer if this feature is enabled. It allows user applications to get fixed length CHAR data that excludes the trailing space padding generated in DBMS during data insertion. This setting corresponds to the DB_RmPad keyword in the dmconfig.ini file. The default setting is disabled.


Related topic:

Data Manipulation