Re: extra spaces

> >     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.

>
> 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.
>

I'm new to the list so I'm not sure if this has already been said, but Perl
DBI has an option to trim trailing spaces in the connect statement. eg:


my $dbh = DBI->connect("dbi:Pg:dbname=mydb",
    'myuser','mypass',
    {RaiseError => 1, AutoCommit => 0, ChopBlanks => 1})
    or die $DBI::errstr;

Cheers