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.
