[BNM] MySQL Character set problem

[Alan Braddish]

Upon further investigation - the offending table has a collation of latin1,
but the column collations are utf8.

Guess I just need to work out how to modify the column collation to latin1
now!


-----Original Message-----
From: Alan Braddish [mailto:alan at webspoke.co.uk] 
Sent: 27 March 2006 17:13
To: 'Brighton New Media'
Subject: [BNM] MySQL Character set problem

Hi,

Am having a problem comparing text from 2 tables in MySQL v4.1

I get the following error from the script:

[MySQL][ODBC 3.51 Driver][mysqld-4.1.12-nt]Illegal mix of collations
(utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation
'='

I have changed the offending table collation type, so that they are now both
latin_1, and restarted the MySQL service, but the problem still persists.
The tables are now both reporting to have the collation type: latin1.

Anyone got any ideas?  Thanks.
Alan



-- 

BNM info/subscription/archives: http://www.brightonnewmedia.org/

BNM archive search: http://www.roddis.org/bnm/search.php
BNM Del.icio.us tag: http://del.icio.us/tag/bnm/
BNM Flickr group: http://www.flickr.com/groups/bnm/

BNM powered by http://www.screen-play.net/