OFBiz数据源是mysql启动报错

OFBiz在mysql数据源下，install时，若在新增GEO表（其他类似）报错：Illegal mix of collations (latin1_general_cs,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation ，

可能是数据库编码问题引起，请查看mysql.ini中的编码

default-character-set=utf8

character-set-server=utf8

然后再对比下OFBiz中entityengine.xml中有关

 <datasource name="localmysqlolap"

            helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"

            field-type-name="mysql"

            check-on-start="true"

            add-missing-on-start="true"

            check-pks-on-start="false"

            use-foreign-keys="true"

            join-style="ansi-no-parenthesis"

            alias-view-columns="false"

            drop-fk-use-foreign-key-keyword="true"

            table-type="InnoDB"

            character-set="utf8"

            collate="utf8_general_ci">

        <read-data reader-name="tenant"/>

        <read-data reader-name="seed"/>

        <read-data reader-name="seed-initial"/>