field with single quote no longer works in 8.3.5

From: hugocoolens <hugocoolens(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: field with single quote no longer works in 8.3.5
Date: 2009-03-07 13:51:21
Message-ID: 049f91c0-8757-4987-ac26-09d513b8ea90@c36g2000yqn.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I have a little php-script to help me learn foreign languages
In my php-code I have the following line:
$query="update wordlist set known=true where dutch='".$preceding."'";

This worked fine on a system running postgres 8.1, however in version
8.3.5 something changed which makes records with the dutch-field
containing single quotes unfindable. You could argue that it's a bad
practice to include records with single quotes in a field but in
language related applications it's unavoidable as single quotes are
used and escaping every single quote when adding data to the database
is something you can't ask the user.

example of a dutch field which causes the problem: hij zei: 'het is
waar'

I guess there must be a way to escape the single quotes automatically
without rebuilding the database

any help appreciated

hugo

Browse pgsql-hackers by date

  From Date Subject
Next Message Rod Taylor 2009-03-07 14:08:07 Re: Out parameters handling
Previous Message Robert Haas 2009-03-07 13:50:19 Re: Out parameters handling