> When using VARCHAR(n) columns, trailing blanks are > stripped off too. This should be avoided or stated > clearly in the docs. My feature request is to change > this to keep trailing blanks on VARCHARs as on LONG > columns. If someone relies on the current handling > make it a connection property.
Unfortunately, this is not feasable with the current 'state of the sources'. Several layers in the database kernel know only about fixed sized values so we have to pad to the defined field length. And stripping trailing blanks after passing these layers is more often the right thing than keeping the padding. Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
