[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