php-db | 2000121

[PHP-DB] Re: [GENERAL] extra spaces From: Roland Roberts (roland <email protected>)
Date: 12/15/00

>>>>> "Soma" == Soma Interesting <dfunct <email protected>> writes:

    Soma> All values called from the database are still padded with
    Soma> extra spaces from the column size in the database. Is this
    Soma> normal - I don't remember this happening when I was using
    Soma> MySQL. I thought usually the database stripped the extra
    Soma> spaces when it retrieved the values.

I guess I missed the orginal post about the problem, but...

Are your columns char() or varchar()? The former is padded in
PostgreSQL but not MySQL. The latter is what you really want.

roland 

-- 
		       PGP Key ID: 66 BC 3B CD
Roland B. Roberts, PhD                             RL Enterprises
roland <email protected>                     76-15 113th Street, Apt 3B
rbroberts <email protected>                          Forest Hills, NY 11375

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>