Error: 1253 - SQLSTATE: 42000 ER_COLLATION_CHARSET_MISMATCH

Description:
Message: COLLATION ‘%s’ is not valid for CHARACTER SET ‘%s’

MySql-Server , , ,

  1. admin
    May 7th, 2009 at 00:45 | #1

    This error occurs when you try to use a collation that is not supported for a particular character set. Each character set defines it own collations. Example as follows:
    COLLATION ‘utf8_bin’ is not valid for CHARACTER SET ‘binary’
    Collation ‘utf8_bin’ is available for character set ‘utf8’ and not for ‘binary’.
    Check your database, table and column DDL for setting the CHARSET. Note that it can be set on the database level, the table level and the
    column level.

  1. No trackbacks yet.