Database error 1064 and charset utf-8 - 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: Database error 1064 and charset utf-8 (/showthread.php?tid=46765) |
Database error 1064 and charset utf-8 - El Forum - 11-14-2011 [eluser]royduin[/eluser] Hi, I'm getting this error database error: 1064, I've found a "solution" but I think it's not necessary. The model function: Code: function update_favorite($data) Call this function from the controler: Code: $this->favorites_model->update_favorite(array( When $rss_last is a "normal" value like: "test" (without quotes) it works fine. When it's a value with more length like (in Dutch): F-Secure vindt malware met certificaat van Maleisische overheid I get this error: Quote:Error Number: 1064 When I change the line Code: 'rss_last' => $rss_last, Code: 'rss_last' => $this->db->escape_str($rss_last), What to do? PS. I thought that CI escapes values automatically when using the Active Record class? |