$ADODB_ANSI_PADDING_OFF

Type	Boolean
Default	False
Driver Support	Limited

Determines whether to right trim CHAR fields (and also VARCHAR for ibase/firebird). Set to true to trim. Default is false. Currently works for the following drivers:

oci8po
ibase
firebird

Syntax

$SQL = "SELECT character_field FROM large_table";
 
$ADODB_ANSI_PADDING_OFF = true;
 
$db->Execute($SQL);