On Thu, 14 Mar 2002, me& wrote:
> I was wondering if its normal behavour that quote_mysql places a backslash
> infront of an underline?
It doesn't for me:
$ exim -be
> ${quote_mysql:abc_def}
abc_def
FX: a dim bell rings ...
Aha! You must be running an old version of Exim. This change was made
for release 3.14 (Apr 12 2000):
6. Changed ${quote_mysql: so that it no longer quotes % and _ because these
must be quoted only when they are part of a pattern, *and not otherwise*. If
they are quoted in error, it doesn't work.
MySQL seems to be very picky about quoting. PgSQL is much better: you
can quote any character you like.
--
Philip Hazel University of Cambridge Computing Service,
ph10@??? Cambridge, England. Phone: +44 1223 334714.