Jacques, are you saying the the default now is unlimited key length for postgres, and other DBs as well?
On Fri, Nov 6, 2015 at 10:27 AM, Jacques Le Roux < [email protected]> wrote: > In trunk it has been replaced by the traditional localpostgres which is > actually now the same but compatible with other DBMS OFBiz configs > > Jacques > > > Le 06/11/2015 19:03, FGomez a écrit : > >> >> Mike, >> >> Thanks you for you feedback, very much appreciated >> >> We will look into it along with the "localpostnew". >> >> >> >> Regards, >> Fernando >> >> >> >> Le 2015-11-05 11:16, Mike a écrit : >> >>> 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 < >>> [email protected]> 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 <[email protected] >>>>>> > >>>>>> 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 <[email protected]> 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è[email protected] >>>>>>>> user = athénaïs athénaï[email protected] >>>>>>>> >>>>>>>> >>>>>>>> * 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 >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>> >> >>
