Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group