Hi Guys, Yes the output is from a upgrade from 3.6.3. I've managed to get it going by running the script "schema.mysql-4.0-4.1.pl". Maybe the script named incorrectly?. Was bit confusing
All good. Thanks heaps On Wed, Oct 15, 2008 at 6:17 PM, Emmanuel Lacour <[EMAIL PROTECTED]>wrote: > 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 >
_______________________________________________ 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
