ActiveRecord & oci8 driver adding double quotes to table names and fields - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20) +--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23) +--- Thread: ActiveRecord & oci8 driver adding double quotes to table names and fields (/showthread.php?tid=35757) |
ActiveRecord & oci8 driver adding double quotes to table names and fields - El Forum - 11-10-2010 [eluser]Andre83[/eluser] I've just noticed that using ActiveRecord and the oci8 driver, writing this piece of code Code: $this->db->get('mytable') Code: SELECT * FROM "mytable" This happens because the Code: $_escape_char Code: " Setting it to an empty string solves the problem; but is this really a possibile solution, or can it be done differently without having to patch the driver? ActiveRecord & oci8 driver adding double quotes to table names and fields - El Forum - 03-25-2011 [eluser]Unknown[/eluser] i have the same problem~~ :exclaim: ActiveRecord & oci8 driver adding double quotes to table names and fields - El Forum - 07-18-2012 [eluser]Unknown[/eluser] This really needs to be documented more clearly or mentioned in the tutorial, maybe as a footnote. Thank you Andre for posting the solution. ActiveRecord & oci8 driver adding double quotes to table names and fields - El Forum - 07-18-2012 [eluser]CroNiX[/eluser] Please feel free to add it to the documentation on Github and issue a pull request. That's the best chance for additions or improvements to CI. |