Dealing with commas in fields

Поиск
Список
Период
Сортировка
От MT
Тема Dealing with commas in fields
Дата
Msg-id 20030801174554.4d9e7c31.mt@open2web.com
обсуждение исходный текст
Ответы Re: Dealing with commas in fields  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список pgsql-general
Hi,

I'm using Postgresql to store customer and product information. Since this is a French language database, some of the
namesinclude commas. Information entered into this database is via html forms and php scripts. When I search the
databasewith a partial name that includes a comma, such as D'Abcd, the database takes longer to find the record I'm
lookingfor than if I searched the database with a partial name that does not include a comma, such as Abcd. I' ve also
noticedif I D'Abcd in a php variable, which is diplayed as the title in the html header, it shows up as D\\\'Abcd, if
thisvariable is passed and displayed in the next page, it shows up as d\\\\\\\\'Abcd. 

Is there a way to enter names with a comma into a field without it causing this strange behavior.

--
Regards,

M. Tessier

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

Предыдущее
От: elein
Дата:
Сообщение: Re: CREATE TABLE with a column of type {table name}
Следующее
От: Tom Lane
Дата:
Сообщение: Re: CREATE TABLE with a column of type {table name}