PostgreSQL Support for remove Space Padding

proiv dashboard

Trail: PROIV Documentation > System Services > PostgreSQL Support for Remove Space Padding

PostgreSQL support to remove trailing space padding from fields

When interacting with a PostgreSQL DB, fixed length PROIV fields are padded with trailing spaces. This means that values written to the DB are padded with trailing spaces (which may not be desirable, or may not be compatible with other processes writing to the DB); also, when comparing values in the DB, the comparison values are also padded with trailing spaces (which means they will not match values in the DB which are not similarly padded).

To address this problem a new configuration setting has been introduce:

proiv.virtualMachine.database.driver.postgres.removePadding

The default value is false, but if set to true (via the config file or dashboard - details TBA)

Then when interacting with the DB (writes or comparisons) trailing spaces will be removed.

Note: Automatic AND deliberate (any entered by the user) trailing spaces will be stripped.

Comment on this topic

Topic ID: 860006