Rabu, 18 Januari 2012

Mysql Mismatch Collations

When get mysql error :
Illegal mix of collations (lati1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
try this code to SQL text :
> show variables like 'coll%'
  collation_connection | latin1_general_ci
  collation_database | latin1_swedish_ci
  collation_server | latin1_swedish_ci

there is a difference between collation_connection and collation database/server, to fix

Tidak ada komentar:

Posting Komentar