It honestly shouldn't be hard to change the structure through phpmyadmin. On Mar 31, 2017 6:09 PM, "Mike" <[email protected]> wrote:
> I had this exact same problem back when I was using mysql. This is how I > finally got mysql to properly render UTF8 > > entity.properties > character-set="utf8" > collate="utf8_general_ci"> > jdbc-uri="jdbc:mysql:// > 10.2.10.101/ofbiz?autoReconnect=true;characterEncoding=UTF-8" > > Also: > my.cnf > character-set-server=utf8 > default-collation=utf8_unicode_ci > > Then (I believe) you have to re-create the database to pick up the UTF8 > stuff and reload the UTF8 data. There may be a way to convert an existing > DB on the fly to UTF8... However: > > The data in the DB is not UTF8 so you are (most likely) screwed. THIS is > exactly why I ditched mysql and went with postgresql, where everything is > UTF8 by default. > > On Fri, Mar 31, 2017 at 2:39 AM, Ingo Wolfmayr <[email protected]> > wrote: > > > Hi everybody, > > > > I have a question regarding special chars: > > > > Environment: Ofbiz trunk, Mysql 5.6 > > Entity Engine: collate="utf8_unicode_ci", jdbc-uri="jdbc:mysql:// > > localhost/ofbiz_test?autoReconnect=true&characterEncoding=UTF-8" > > > > I have the following strings: > > 1) Käse > > 2) Akrapovič > > > > The first one is working. The second becomes Akrapovi? > > > > Both strings work in the online demo. Does anyone has an idea what I may > > do wrong? > > > > Best regards, > > Ingo > > >
