Why not change SQLObject to used '' instead of \' since it is the SQL
standard way to write a single quote. The other databases seems to
support this syntax.
fred[601]> sqlite3
SQLite version 3.3.4
Enter ".help" for instructions
sqlite> create table foo (bar char(32));
sqlite> insert into foo (bar) values ('it''s a test');
sqlite> select * from foo;
it's a test
sqlite>
-bash-2.05b$ mysql test
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1879846 to server version: 4.1.15
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create table foo (bar char(32));
Query OK, 0 rows affected (0.05 sec)
mysql> insert into foo (bar) values ('it''s a test');
Query OK, 1 row affected (0.01 sec)
mysql> select * from foo;
+-------------+
| bar |
+-------------+
| it's a test |
+-------------+
1 row in set (0.00 sec)
On Jul 25, 2007, at 8:49 AM, Oleg Broytmann wrote:
> On Wed, Jul 25, 2007 at 08:34:37AM -0700, Fred C wrote:
>> Right now I am using 8.2 on FreeBSD.
>
> There is a bug report at the SF tracker:
> https://sourceforge.net/tracker/index.php?
> func=detail&aid=1759920&group_id=74338&atid=540672
> about Pg 8.2.3 on Darwin. It seems Pg 8.2 on Darwin forbid \'
> style.
>
> Oleg.
> --
> Oleg Broytmann http://phd.pp.ru/
> [EMAIL PROTECTED]
> Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
