On 15 Dec 2000, Roland Roberts wrote:
> >>>>> "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.
According to "Postgres: Introduction and Concepts", varchar is slower
than char. So if you (like me) want to use char and get rid of the
padding spaces, you may use a regex replacement, as in
while (@row=$result->fetchrow)
{
$row[0] =~ s/[\s]+$//;
}
in perl, or
$array["name"]=preg_replace("'[\s]+$'", "", $array["name"], -1);
in PHP.
--
Alvaro Herrera (<alvherre[@]protecne.cl>)