| From: | Roland Roberts <roland(at)astrofoto(dot)org> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | php-general(at)lists(dot)php(dot)net, php-db(at)lists(dot)php(dot)net |
| Subject: | Re: extra spaces |
| Date: | 2000-12-16 03:59:37 |
| Message-ID: | m2d7et6mom.fsf@tycho.rlent.pnet |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
>>>>> "Soma" == Soma Interesting <dfunct(at)telus(dot)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(at)rlenter(dot)com 76-15 113th Street, Apt 3B
rbroberts(at)acm(dot)org Forest Hills, NY 11375
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guang Mei | 2000-12-16 04:27:02 | Does postgresql support storage clause when creating tables |
| Previous Message | Miles Thompson | 2000-12-16 02:59:09 | Re: [PHP-DB] extra spaces |