Re: Bugs: fill value with cursor

From: Oskar Berggren <beo(at)sgs(dot)o(dot)se>
To: "Programmazione softsystem(dot)it" <prog(at)softsystem(dot)it>
Cc: pgsql-ODBC(at)postgresql(dot)org
Subject: Re: Bugs: fill value with cursor
Date: 2002-06-28 13:58:14
Message-ID: 3D1C6B76.8090400@sgs.o.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Programmazione softsystem.it wrote:
> Hi,
> Excuse my bad english.
> The value of field created using insert into cursor or similar are
> filling with space ( "one" -> "one "), this is not good and very
> different with another database windows.
> This is a large block for using application windows with database for
> s.o. unix.

What are the datatype of the field? If it is char(X) PostgreSQL will
pad or truncate it so that it is always X characters long. Try using
varchar(X) (where X is maximum length) instead.

/Oskar

--
/-----------------------+---------------------------+------------------\
| SGS Datanätgrupp | www.sgs.studenthem.gu.se | Office Hours |
| Utlandagatan 24 | E-mail: dng(at)sgs(dot)o(dot)se | Mon-Thur 17-19 |
| 412 80 Göteborg | Phone: 031-7081335 | |
\-----------------------+---------------------------+------------------/

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Webb Sprague 2002-06-28 21:38:51 Pass through query help (please ...:)
Previous Message Dave Page 2002-06-28 13:44:45 Re: Bugs: fill value with cursor