I bookmarked this article regarding mysql and utf8 a couple of years ago. It convinced me to always use uft8.
http://www.bluetwanger.de/blog/2006/11/20/mysql-and-utf-8-no-more-question-marks/ On Sat, Mar 12, 2011 at 8:56 PM, Paul Foxworthy <[email protected]> wrote: > Hi all, > > The recent discussion at > http://ofbiz.135035.n4.nabble.com/data-base-tp3323306p3325260.html > http://ofbiz.135035.n4.nabble.com/data-base-tp3323306p3325260.html seems to > suggest the default encoding in OFbiz could now be utf8. > > Are there any disadvantages, or should we just go and do it? > > Cheers > > Paul Foxworthy > > > Mike Z wrote: >> >> You probably want to dump the latin1 character set and use UTF8. If >> you use latin1, you can forget about getting a multi-language capable >> ofbiz installation (I learned the hard way). Try these: >> >> table-type="InnoDB" >> character-set="utf8" >> collate="utf8_general_ci"> >> >> >> On Wed, Mar 9, 2011 at 10:58 AM, James Lawton >> <[email protected]> wrote: >>> I have just setup a brand new install on a machine with Windows 7 32 bit >>> + >>> MySQL 5.5.9 >>> >>> >>> >>> After creating the databases and granting privileges to the user and >>> password named in the entityengine.xml file I ran the command: >>> >>> >>> >>> "ant run-install-seed" from the directory where ofbiz 10.04 OOTB is >>> installed - This install worked fine with MySQL 5.1. >>> >>> >>> >>> I get the following error back (actually tons of these errors) >>> >>> >>> >>> [java] Error was: >>> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: >>> You have an error in your SQL syntax; check the manual that corresponds >>> to >>> your MySQL server version for the right syntax to use near 'TYPE InnoDB >>> CHARACTER SET latin1 COLLATE latin1_general_cs' >>> >>> >>> >>> >>> >>> Has anyone seen this before? >>> >>> >>> >>> Dead in the water at this point >>> >>> >>> >>> Thanks >>> >>> James >>> >>> >> > > > -- > View this message in context: > http://ofbiz.135035.n4.nabble.com/Installing-clean-new-in-MySQL-5-5-9-tp3344284p3351321.html > Sent from the OFBiz - User mailing list archive at Nabble.com. >
