View Single Post

  #10 (permalink)  
Old 01-03-2008
Steve
 
Posts: n/a
Default Re: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and(utf8_general_ci,COERCIBLE) for operation 'if'

On Jan 3, 12:05 pm, Steve <steve.lo...@gmail.com> wrote:
> > > Please post the result of SHOW CREATE TABLE _ImportTable, so that I
> > > can attempt to duplicate the problem. I am particularly interested
> > > in the default charset for the table.

>
> > Or SHOW FULL COLUMNS FROM <tablename>
> > --
> > Rik Wasmus

>
> Rik / Charles
>
> Here's a link to a text file with the outputs of both commands on both
> servers:
>
> http://www.jabberwonk.com/dump/mysql_error.txt


I also included the full query in the .txt file (I had trimmed some
stuff out for clarity here)

Steve
Reply With Quote