Re: Bugs: fill value with cursor - Mailing list pgsql-odbc

From Oskar Berggren
Subject Re: Bugs: fill value with cursor
Date
Msg-id 3D1C6B76.8090400@sgs.o.se
Whole thread Raw
In response to Bugs: fill value with cursor  ("Programmazione softsystem.it" <prog@softsystem.it>)
List 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@sgs.o.se      |   Mon-Thur 17-19 |
| 412 80  Göteborg      | Phone:  031-7081335       |                  |
\-----------------------+---------------------------+------------------/




pgsql-odbc by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Bugs: fill value with cursor
Next
From: Webb Sprague
Date:
Subject: Pass through query help (please ...:)