< Column Name Case   (Previous) Table of Contents (Next)   Other Quirks >

CHAR Column Padding

Database Padded Notes
Access 2000 yes
DB2 8.1 yes
Firebird 1.5 yes
FrontBase 4.1 no
MySQL 4.0 – 4.1 no
Oracle 9.2 yes
PostgreSQL 7.4 yes
SQL Server 2000 yes Except when column defined as nullable
SQLite 2.8 no
Sybase ASE 12.5 yes Except when column defined as nullable

Output formatting handled by PEAR::DB's DB_PORTABILITY_RTRIM configuration option.