Disable Right Trim for VARCHAR Data

Administrators use this system setting to specify whether the automatic removal of trailing spaces from varchar columns is enabled (Off) or disabled (On). For example, when this property is enabled (Off), when a user starts entering values in a field, the filter dialog automatically trims any trailing spaces.

Valid Values

• On —

  Preserves trailing whitespaces in varchar columns. If you primarily use Oracle Database sources, you might want to keep the default Oracle Database behavior of preserving trailing whitespaces rather than removing them. When you toggle this property on, you avoid the overhead of trimming spaces, and this can improve performance.

  If you disable this property (set it to On) and you construct a filter such as PRODUCT_DESCRIPTION = 'My Product '), you must make sure the amount of trailing whitespace used exactly matches the varchar column value. If you don't, the filter won't correctly match the data values.

• Off — Trims trailing whitespaces in varchar columns when processing queries. This is the default for Oracle Analytics. For example, if a user enters the text 'My Product ', it trims it to 'My Product'. Default

Apply Required

Yes.

Change Effective

After a few minutes.

Edition

Professional and Enterprise.

API Key and Values

API Key — DataQueryDisableRightTrimVARCHARData

API Values —

• YES
• NO

Documentation Links

• When Do System Settings Take Effect?
• Typical Workflow for Using System Setting REST APIs
• Examples for System Setting REST APIs