Hi,
for more info see: http://dev.mysql.com/doc/refman/5.0/en/identifiers.html where is stated: "The identifier quote character is the backtick (`):"
greetings, Luuk
On 26.8.2007, at 3.41, XhE wrote:
Found a problem with dovecot 1.0.3 and mysql authentication
I got a problem with escaping of mysql table names. Usually, when a mysql table name has some special character (in my case there is a table beginning with the # character) one has to put into these special quotes --- ` ---; others like ' oder " are not recognized. But dovecot somehow doesn't allow me to do that.
I don't know what you mean by putting into special quotes. Can you given an example? But if you tried to use # it would be treated as a comment, so you'd have to put the whole setting inside quotes:
password_query = "select password, from #table where .."