Re: Problems with Blank space

Поиск
Список
Период
Сортировка
От Joe Conway
Тема Re: Problems with Blank space
Дата
Msg-id 03a601c11f79$97e362d0$48d210ac@jecw2k1
обсуждение исходный текст
Ответ на Problems with Blank space  ("Eric, Audet" <eaudet@scc.ca>)
Список pgsql-general
> I am not sure if this is a database issue or a DBI::Pg issue.
>
> When I do a select * from tablea .... all fields specified as fix length
> text field ... return the data with blank space.
>
> Example:
> "Eric" returns "Eric****************" where * are blank spaces.
>
> Is this normal?

Yes, use varchar() or text instead of char() if you don't want the spaces.
See:

http://www.postgresql.org/idocs/index.php?datatype-character.html

HTH,

-- Joe


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