Re: extra spaces

Roland Roberts <roland@astrofoto.org>

From: Roland Roberts <roland@astrofoto.org>
To: pgsql-general@postgresql.org
Cc: php-general@lists.php.net, php-db@lists.php.net
Date: 2000-12-16T03:59:37Z
Lists: pgsql-general
>>>>> "Soma" == Soma Interesting <dfunct@telus.net> 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@rlenter.com                     76-15 113th Street, Apt 3B
rbroberts@acm.org                          Forest Hills, NY 11375