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
>
>
