Re: [Exim] quote_mysql & underscores

Top Page
Delete this message
Reply to this message
Author: Philip Hazel
Date:  
To: me&
CC: exim-users
Subject: Re: [Exim] quote_mysql & underscores
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.