Yes, if you're using fixed-length fields then the value is padded out to the
length that the field is fixed to :-)
I'm sure Perl has some facility for stripping NULLs off of strings, I
suggest using it here or changing the data type in PG...
Good luck!!
> I am not sure if this is a database issue or a DBI::Pg issue.
>
> When I do a select * from tablea .... all fields specified as fix length
> text field ... return the data with blank space.
>
> Example:
> "Eric" returns "Eric****************" where * are blank spaces.
>
> Is this normal?
>
> Eric
>