Michael Vrable wrote: > On Wed, Feb 20, 2008 at 09:34:34PM -0700, Mark Johnson wrote: > >> PostgreSQL gives a warning for '', but accepts it; it prefers \'. >> MySql takes the ''; I'm not sure about \'. Obviously SQLite won't >> take the \'. >> > > What version of PostgreSQL is this? I haven't noticed that, and > according to the online documentation for version 8.3, '' is > recommended, as at some point in the future PostgreSQL may stop > recognizing backslashes as escape characters for standards compliance > and security reasons (controlled by the standard_conforming_strings > option, which for now defaults to off). > I was using version 8.2.x. I haven't changed to 8.3.0 as my main version just yet. Thanks for the info. > >> However, the real problem is that it is not gnucash-gda code which is >> doing the escaping of the single quote. It is libgda, probably the >> SQLite provider. Therefore not under this project's control. >> > > Yes, that is the real problem. > > --Michael Vrable > > Mark
_______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
