Re: PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?

--- Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk> wrote:
>
> On 28/05/2004 20:46 Jeff Eckermann wrote:
> > I had a thought that the ODBC driver could be
> > stripping the trailing spaces, but the test I just
> did
> > (using MS Access via ODBC) worked fine.
>
> But that's using a different ODBC driver so won't
> show a possible bug in
> the PG driver.

PgAdminII uses the psqlodbc driver. It's pgAdminIII
that does not.

>
> > Thinking some more, I used a "text" type field for
> my
> > test. I have some recollection that varchar(n)
> fields
> > _will_ strip trailing spaces. But I'm too lazy to
> > test that right now.
>
> I was testing using a varchar(n) field.

Which I just tested, and found to work fine. My
recollection of the space-stripping behaviour of
varchar(n) appears to be off.

All of which is academic, seeing that the OP solved
his problem by using char(n). But that leaves wide
open the question of why that would work, when
varchar(n) or text do not.

>
> --
> Paul Thomas
>
+------------------------------+---------------------------------------------+
> | Thomas Micro Systems Limited | Software Solutions
> for
> Business |
> | Computer Consultants |
> http://www.thomas-micro-systems-ltd.co.uk |
>
+------------------------------+---------------------------------------------+
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the
> postmaster-------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/