PBTrimCharColumns – PB Docs 2019

Description

Specifies whether PowerBuilder should trim trailing spaces from
data values retrieved from the following datatypes: Char, NChar, Text, NText, Char for Bit
Data, VarChar, NVarChar, and VarChar for Bit Data.

Applies to

ODBC

OLE DB

Syntax

Default value

‘NO’

Usage

This parameter can only be set in the pbodb.ini file. For ODBC,
you can set the TrimSpaces parameter in the Database Profile Setup
dialog box or in code to perform the same function.

By default, PowerBuilder trims spaces from the following
datatypes: Char, NChar, Text, NText, Char for Bit
Data, VarChar, NVarChar, and VarChar for Bit Data.

If your DBMS makes a distinction between Char data with trailing
spaces and Char data without trailing spaces when evaluating a WHERE
clause expression, you might receive the message Row changed between
retrieve and update when your DataWindow object’s update properties are
set to “Key and updateable columns”. To prevent this, change your
DataWindow object’s update properties. In embedded SQL, you can check
Sqlca.Sqlnrows after each update to determine if the update took place.
Avoid using Char data columns in the WHERE clause of an UPDATE or DELETE
statement when PBTrimCharColumns=’YES’.

Examples

To specify that PowerBuilder should trim trailing spaces, add the
following line to the section for the database you are accessing:

See also

TrimSpaces