This setting enables a non ANSI standard behavior to allow VARCHAR fields to contain trailing spaces.

 

ALLOWTRAILINGSPACEINVARCHAR=1

 

Enables trailing spaces in VARCHAR fields.

Default = 0.

 

Environments: Client, Windows CONNX

Configuration Manager: CONNX Settings; Current Key = CONNX; Key Value/Value Name =  ALLOWTRAILINGSPACEINVARCHAR