List:General Discussion« Previous MessageNext Message »
From:Tulong! Date:August 1 2005 12:02pm
Subject:Illegal mix of collations (utf8_general_ci,IMPLICIT) and
(latin1_swedish_ci,COERCIBLE) for operation '='
View as plain text  
Here's how the problem starts.
1. Entered Korean characters in a form.
2. Press submit and I receive that error.

Programming Language: PHP 5.0.4
Database: MySQL 4.1.13
Operating System: Windows XP SP2

Charset for the page: UTF-8
Charset for the table: UTF-8
Charset for the database: UTF-8

So where does latin1_swedish_ci come from? I tried entering the same 
string in phpMyAdmin and I didn't receive the error.

SNIPPET:

$query = "SELECT `id` FROM `table1` WHERE `column1`='$var'";
$result = mysql_query ($query, $link);

Thread
Illegal mix of collations (utf8_general_ci,IMPLICIT) and(latin1_swedish_ci,COERCIBLE) for operation '='Tulong!1 Aug
  • Re: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='Gleb Paharenko1 Aug
    • Re: Illegal mix of collations (utf8_general_ci,IMPLICIT) and(latin1_swedish_ci,COERCIBLE) for operation '='Mark Dacasco1 Aug
      • Re: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE)for operation '='Bastian Balthazar Bux1 Aug
        • Re: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='Mark1 Aug
          • Re: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE)for operation '='Bastian Balthazar Bux1 Aug
            • Re: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '=' (SOLVED)Mark2 Aug