Re: extra spaces

Поиск
Список
Период
Сортировка
От Roland Roberts
Тема Re: extra spaces
Дата
Msg-id m2d7et6mom.fsf@tycho.rlent.pnet
обсуждение исходный текст
Ответ на extra spaces  (Soma Interesting <dfunct@telus.net>)
Ответы Re: extra spaces  (Alvaro Herrera <alvherre@protecne.cl>)
Список pgsql-general
>>>>> "Soma" == Soma Interesting <dfunct@telus.net> writes:

    Soma> All values called from the database are still padded with
    Soma> extra spaces from the column size in the database. Is this
    Soma> normal - I don't remember this happening when I was using
    Soma> MySQL. I thought usually the database stripped the extra
    Soma> spaces when it retrieved the values.

I guess I missed the orginal post about the problem, but...

Are your columns char() or varchar()?  The former is padded in
PostgreSQL but not MySQL.  The latter is what you really want.

roland
--
               PGP Key ID: 66 BC 3B CD
Roland B. Roberts, PhD                             RL Enterprises
roland@rlenter.com                     76-15 113th Street, Apt 3B
rbroberts@acm.org                          Forest Hills, NY 11375

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

Предыдущее
От: Miles Thompson
Дата:
Сообщение: Re: [PHP-DB] extra spaces
Следующее
От: "Guang Mei"
Дата:
Сообщение: Does postgresql support storage clause when creating tables