DMZ 1.7.1 (DataMapper OverZealous Edition)

[eluser]bonatoc[/eluser]
Cool. But odd, my tables use MyISAM with no problem.

I suppose DMZ tables should be using the recommended engine, if any. Keep in mind that there is :

- The MySQL default engine setting (in the mysql config file)
- The DB default engine setting

After installing DMZ demo MySQL tables, it's not automatic that newly created tables are conforming to DMZ requirements (if any).
Also, I personally set the default charset as :

Encoding : UTF-8 Unicode (utf8)
Collation : utf8_general_ci

This may be of interest, even if unrelated to your problem :
http://philsturgeon.co.uk/news/2009/08/U...odeIgniter

You may have to do some cleaning by building your own loop PHP scripts using utf8_encode and such, for updating columns containing text, if you're migrating from already populated tables using a different encoding (ISO-8859 or other).

http://paulkortman.com/2009/07/24/mysql-...onversion/

With a dedicated server, you may as well declare your specific site via htaccess : this allows you to keep sites using other encodings on the same webserver untouched.

http://www.askapache.com/htaccess/settin...ccess.html