ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:reference:adodb_ansi_padding_off

$ADODB_ANSI_PADDING_OFF

TypeBoolean
DefaultFalse
Driver SupportLimited

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);
v5/reference/adodb_ansi_padding_off.txt · Last modified: 2016/01/13 02:30 by mnewnham