Back when I was using mysql I had to do this in entityengine.xml jdbc-uri="jdbc:mysql:// 10.2.10.101/ofbiz?autoReconnect=true;characterEncoding=UTF-8"
However, then reason I dumped mysql was the limiting of key length to 21. This is fine if you like integers but throughout the demo data there were numerous examples of using alpha keys for the primary key and this 21 character limit became real annoying. I then later switched to "localpostnew" type in entityengine.xml which has no limits of ANY field and that solved the issue, and solved UTF8 issues as well. On Wed, Nov 4, 2015 at 11:16 PM, Jacques Le Roux < jacques.le.r...@les7arts.com> wrote: > Le 05/11/2015 01:27, FGomez a écrit : > >> Mike and Pierre >> >> Yes we are using mysql and its set as latin1 (server and DB). >> >> W'll change it to utf-8 and will open a JIRA for reference. >> > > Better to to fill an entry in the wiki FAQ > > https://cwiki.apache.org/confluence/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo > > Check this page before > https://cwiki.apache.org/confluence/display/OFBIZ/No+Spam > > Jacques > > > >> FYI >> >> http://stackoverflow.com/questions/3513773/change-mysql-default-character-set-to-utf-8-in-my-cnf >> >> >> Regards, >> Fernando >> >> >> >> Le 2015-11-04 16:17, Mike a écrit : >> >>> It should, as long as your database is unicode (i.e. postgresql). If >>> you're using mysql (my bet) it is not unicode by default. >>> >>> On Wed, Nov 4, 2015 at 12:24 PM, Pierre Smits <pierre.sm...@gmail.com> >>> wrote: >>> >>> Hi Fernando, >>>> >>>> Feel free to create a JIRA issue regarding this. >>>> >>>> Best regards, >>>> >>>> Pierre Smits >>>> >>>> *OFBiz Extensions Marketplace* >>>> http://oem.ofbizci.net/oci-2/ >>>> >>>> On Wed, Nov 4, 2015 at 6:26 PM, FGomez <fgo...@mail.com> wrote: >>>> >>>> Hi >>>>> >>>>> Does ofbiz support unicode for user login ID. >>>>> >>>>> I have created users and I am getting the following Erreur at the >>>>> login? >>>>> >>>>> user = arsène arsèn...@domain.com >>>>> user = athénaïs athénaïs...@domain.com >>>>> >>>>> >>>>> * was able to assign the email with an erreur message. >>>>> >>>>> The Following Errors Occurred: >>>>> >>>>> Error calling event: org.ofbiz.webapp.event.EventHandlerException: >>>>> Problems processing event: java.lang.IllegalArgumentException: Control >>>>> character in cookie value or attribute. (Control character in cookie >>>>> value >>>>> or attribute.) >>>>> >>>>> french >>>>> >>>>> >>>>> >>>>> tested on >>>>> http://demo-stable-ofbiz.apache.org/partymgr/control/backHome >>>>> >>>>> >>>>> Regards, >>>>> Fernando >>>>> >>>>> >>>>> >>>>> >> >>
