Re: Bugs: fill value with cursor

Поиск
Список
Период
Сортировка
От Oskar Berggren
Тема Re: Bugs: fill value with cursor
Дата
Msg-id 3D1C6B76.8090400@sgs.o.se
обсуждение исходный текст
Ответ на Bugs: fill value with cursor  ("Programmazione softsystem.it" <prog@softsystem.it>)
Список 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 по дате отправления:

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re: Bugs: fill value with cursor
Следующее
От: Webb Sprague
Дата:
Сообщение: Pass through query help (please ...:)