Re: Please HELP: insert row ...
От | Albert REINER |
---|---|
Тема | Re: Please HELP: insert row ... |
Дата | |
Msg-id | 20001014164704.A407@frithjof обсуждение исходный текст |
Ответ на | Please HELP: insert row ... ("Thu Huynh" <thu_huynh@hotmail.com>) |
Список | pgsql-novice |
On Sat, Oct 14, 2000 at 04:15:11AM +0000, Thu Huynh wrote: > Hello, > > Does anyone know how to insert/update data that contains single quote (') > into a field? Data such as: John's house is in Dalas. Via Perl, I always wrap any strings with the following sub (adapted from a similar sub of mmusic by ChLorenz@csi.com, and incorporating advice from this list (David Rugge, 1 Aug 1999, and some experimentation). sub stdstr { my $or = $_[0]; $or =~ s /\\/\\\\/g; $or =~ s /\'/\\\'/g; $or =~ s /\"/\\\"/g; $or =~ s /%/\\%/g; return $or; } Basically you have to quote \ ' " % (even though I am no longer sure about the reasons for some of these; but quoting certainly cannot do any harm). Works for me. HTH, Albert. -- -------------------------------------------------------------------------- Albert Reiner <areiner@tph.tuwien.ac.at> Deutsch * English * Esperanto * Latine --------------------------------------------------------------------------
В списке pgsql-novice по дате отправления: