On Wed, Oct 15, 2008 at 01:34:28PM +1100, Chamara Peris wrote: > Hi All, > ) ENGINE=InnoDB AUTO_INCREMENT=31223 DEFAULT CHARSET=latin1 |
Is this the statement after upgrade or on your fresh 3.8.1 install? RT >= 3.8.1 uses UTF-8, you seems to have the wrong charset. If it's the stetement after upgrade, then you missed reading UPGRADING.mysql. If it's a fresh 3.8.1 install, how did you create your tables? If using rt-setup-database, this should be UTF-8, if using somethink like "cat schema.mysql | mysql rt", then this would be because you're default is latin1. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
