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 | |
\-----------------------+---------------------------+------------------/
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 |