On Tue, 6 Jun 2000, robert rotman wrote:
> when i qoute in a mysql-lookup "username='${quote_mysql:$local_part}'"
> usernames with an "_" are not recognized
> exim qoutes this to eg.: "user\_name" which is not recognized by mysql.
>
> exim only recognice it when its written as "user\\_name" in the mysql
> database.
>
>
> anyone any suggestions?
Upgrade to Exim 3.14, which has this change:
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.
This problem doesn't arise for pgsql, where a more sensible attitude is
taken to backslashed special characters that aren't actually considered
to be special.
--
Philip Hazel University of Cambridge Computing Service,
ph10@??? Cambridge, England. Phone: +44 1223 334714.
