I think this can be a problem and would recommend to force UTF8 for all tables, if there are only LATIN1 data they should not be touched in any way and if all is UTF8 there is no point of mixing
Well, normally we use LATIN1 historical for some thounsand tables but the whole database for postfix/dovecot/dbmail is is UTF8 from the beginning Am 24.01.2011 11:53, schrieb Claudio Prono: > > > Reindl Harald ha scritto: >> show create table tablename; >> >> > Ok, something strange is come out. > > Here is the list of tables on postfix database: > > +-----------------------+ > | Tables_in_postfix | > +-----------------------+ > | admin | > | alias | > | alias_domain | > | config | > | domain | > | domain_admins | > | fetchmail | > | log | > | mailbox | > | quota | > | quota2 | > | vacation | > | vacation_notification | > +-----------------------+ > 13 rows in set (0.00 sec) > > All the tables have as default charset "latin1" except for > "vacation_notification". That is "DEFAULT CHARSET=utf8" > > My system is an OpenSuSE 11.2, and mysql is mysql-5.1.49-0.1.1.x86_64. > > Can be this the problem ? I have checked this into another similar > server, and the results are the same... all the tables are latin1, > except for "vacation_notification", wich is "utf8", but there is no > trace of this problem on the other server...... > > Any idea? > > Cordially, > > Claudio Prono. > -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/
signature.asc
Description: OpenPGP digital signature
