Main | Search

Question
Sort: Ascending / Descending
Illegal mix of collations

Answer
Illegal mix of collations

This happens in MySQL 4.1/5.x when the Dragonfly database connection is set to utf8 but your tables are in a different collation, for example latin1_general_ci instead of the needed utf8_general_ci.

To fix this problem you may do one of the following things:

1. Fix the database table and column collations
Code:
ALTER TABLE moo_**** DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;

2.Change config.php
PHP:
define('DB_CHARSET', null);

Ofcourse you may choose any other collation if your website is specialy aimed at the Swedish language for example. then you may choose utf8_swedish_ci as collation.


stopsoftwarepatents.eu petition banner
User Info [x]

Welcome Anonymous

Nickname
Password
(Register)

Languages [x]

Community [x]

Support for DragonflyCMS in a other languages:

Deutsch
Español

X-links [x]
UltraEdit Browse Happy logo Firefox MySQL PostgreSQL Valid CSS! Valid XHTML 1.0! Unicode Encoded Badge NukeBiz Resources Raven DragonflyCMS Dedicated Now InsideSupport Lampe Berger

Preview theme [x]
Each user can view the site with a different theme.
Themes marked with a * also change the forum look.


You are seeing squares or questionmarks on this page?

All content of this website is copyrighted by the Creative Commons NC-SA
The logos and trademarks used on this site are the property of their respective owners
We are not responsible for comments posted by our users, as they are the property of the poster.
Our server runs on a P3 1.2GHz with 512MB RAM with no accelerators
Support GoPHP5.org
This page generated in 0.1058 seconds with 8 DB Queries in 0.1702 seconds
Memory Usage: 1.49 MB
Interactive software released under GNU GPL, Code Credits, Privacy Policy