In PostgreSQL 9.1, does a prepared statement allow searches with apostrophes?
For example:
[code]dim ps as PostgreSQLPreparedStatement = _
db.Prepare(“SELECT * FROM customers WHERE lastname = $1”)
ps.bind(0,“O’Conner”)
dim rs as RecordSet = ps.SQLSelect
[/code]
Or do i have to do something like this:
[code]dim ps as PostgreSQLPreparedStatement = _
db.Prepare(“SELECT * FROM customers WHERE lastname = $1”)
ps.bind(0,“O’'Conner”)
dim rs as RecordSet = ps.SQLSelect
[/code]