| From: | "Brett W(dot) McCoy" <bmccoy(at)chapelperilous(dot)net> |
|---|---|
| To: | Soma Interesting <dfunct(at)telus(dot)net> |
| Cc: | <php-general(at)lists(dot)php(dot)net>, <php-db(at)lists(dot)php(dot)net>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: extra spaces |
| Date: | 2000-12-14 23:18:15 |
| Message-ID: | Pine.LNX.4.30.0012141817440.6523-100000@chapelperilous.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 14 Dec 2000, Soma Interesting wrote:
> I'm using PHP & PostgreSQL.
>
> All values called from the database are still padded with extra spaces from
> the column size in the database. Is this normal - I don't remember this
> happening when I was using MySQL. I thought usually the database stripped
> the extra spaces when it retrieved the values.
>
> How do you recommend dealing with this, using a PHP command to strip every
> value from the database - or can I change something in the database to have
> it strip the spaces auto magic like?
Sounds like you are using fixed length strings (char) rather than variable
length strings (varchar).
-- Brett
http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
A fool-proof method for sculpting an elephant: first, get a huge block of
marble; then you chip away everything that doesn't look like an elephant.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert B. Easter | 2000-12-14 23:54:39 | Re: create trigger |
| Previous Message | Sandeep Joshi | 2000-12-14 23:04:34 | create trigger |