List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:August 1 2005 12:23pm
Subject:Re: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='
View as plain text  
Hello.


Please, send the output of the following statements:
 
  show variables like '%char%';
  show create table table1;


"Tulong!" <myprogram@stripped> wrote:
> 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);
> 
> 


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com



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