[Dbix-class] "group" as a column name
Bogdan Lucaciu
bogdan at wiz.ro
Sat Nov 11 12:42:50 GMT 2006
On Sat, 2006-11-11 at 05:21 -0500, Mike Friedman wrote:
> The way to get around this is to quote the column names in the SQL
> (`group` instead of group). Is there a way to get DBIC to do this?
from DBIx::Class::Storage::DBI POD:
quote_char
Specifies what characters to use to quote table and column names.
If you use this you will want to specify name_sep as well.
quote_char expects either a single character, in which case is it
is placed on either side of the table/column, or an arrayref of
length 2 in which case the table/column name is placed between the
elements.
For example under MySQL you’d use "quote_char => ’‘’", and user SQL
Server you’d use "quote_char => [qw/[ ]/]".
name_sep
This only needs to be used in conjunction with quote_char, and is
used to specify the charecter that seperates elements (schemas,
tables, columns) from each other. In most cases this is simply a
".".
bogdan
More information about the Dbix-class
mailing list