Trim spaces from string data using AdsConnection

Connection string

This Advantage .NET Data Provider connection string can be used for connections to Sybase Advantage.

Fields of type String will have trailing white spaced trimmed on retrieval.

Data Source=\\myserver\myvolume\mypat\mydd.add;User ID=myUsername;
Password=myPassword;ServerType=REMOTE;TrimTrailingSpaces=TRUE;

If FALSE is specified, then trailing white space is maintained on the values when they are retrieved. This means that a fixed length String field with a width of 10, for example, will always return 10 characters when the value is retrieved; it is padded with as many spaces as necessary.