非法混合整理操作“=”

Question

我想从“invoice_data”表中选择数据，其中公司名称的值将根据电子邮件的值从表“crm_accounts”中选择。我的错误就像

非法组合排序规则(utf8_unicode_ci，隐式)和(utf8_general_ci，隐式)操作“=”

这是我的模型代码：

public function view_invoice($email)
    {
        $this->db->select('invoice_data.*, crm_accounts.company');
        $this->db->from('invoice_data');
        $this->db->join('crm_accounts', 'invoice_data.cname = crm_accounts.company', 'inner');
        $this->db->where('crm_accounts.email', $email);
        $query = $this->db->get();
        return $query->result_array();
    }

Answer 1

试试这个；

public function view_invoice($email)
{
    $this->db->select('invoice_data.*, crm_accounts.company');
    $this->db->from('invoice_data');
    $this->db->join('crm_accounts', 'invoice_data.cname = crm_accounts.company COLLATE utf8_unicode_ci', 'inner');
    $this->db->where('crm_accounts.email', $email);
    $query = $this->db->get();
    return $query->result_array();
}