Rails - Apr 2005 - Is there any reason Rails doesn't use backticks?

I''ve been bitten a few times with field names or table names that are
valid inside of backticks (e.g. `table`.`field`), but invalid when
used without.  PHPMyAdmin uses backticks by default, so there is
usually no way for me to tell in advance if I''m using a SQL reserved
word or not.

Is there any reason Rails does not use backticks by default?  Do some
databases behave adversely in their presence?

Thanks,
Duane Johnson
(canadaduane)

On Apr 9, 2005 2:16 PM, Duane Johnson
<duane.johnson-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
> Is there any reason Rails does not use backticks by default?  Do some
> databases behave adversely in their presence?
Backticks are unique to MySQL afaik. The standard specifies double
quotes, and the convention for most databases is to use double quotes,
but even then, people can turn off the database''s support for it.

SQL Server for example, allows you to turn it off, and then only [ and
] are valid delimiters.

Leon