Re: PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?

Поиск
Список
Период
Сортировка
От Paul Thomas
Тема Re: PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?
Дата
Msg-id 20040529095856.A16618@bacon
обсуждение исходный текст
Ответ на Re: PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
Ответы Re: PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
Список pgsql-general
On 28/05/2004 20:46 Jeff Eckermann wrote:
> I had a thought that the ODBC driver could be
> stripping the trailing spaces, but the test I just did
> (using MS Access via ODBC) worked fine.

But that's using a different ODBC driver so won't show a possible bug in
the PG driver.

> Thinking some more, I used a "text" type field for my
> test.  I have some recollection that varchar(n) fields
> _will_ strip trailing spaces.  But I'm too lazy to
> test that right now.

I was testing using a varchar(n) field.

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for
Business             |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: turn WAL off.
Следующее
От: Michal Táborský
Дата:
Сообщение: Use arrays to store multilanguage texts