On a side note, the only reason this isn't the default in OFBiz is that if you use UTF-8 the size of each text column will be reduced to 1/3 of its specified size because each UTF-8 character requires 3 bytes in MySQL, and the size of a column in MySQL is in terms of bytes, and not in terms of characters. Every other DB in the world (that I'm aware of) uses characters for column size, MySQL is just weird.
-David On Feb 25, 2011, at 1:51 PM, Mike wrote: > As I recall (I use postgres now), I had trouble getting multi-language > support to work properly in mysql until I made the following changes > to entityengine.xml. > > The default config shows this: > > character-set="latin1" > collate="latin1_general_cs" > > I believe I had to change the above to: > > character-set="utf8" > collate="utf8_general_ci" > > When I did the above, I was able to support a multi-language > environment...i.e, write product info in multiple languages. > Something to think about. > > > On Fri, Feb 25, 2011 at 12:04 PM, Erwan de FERRIERES > <[email protected]> wrote: >> Le 25/02/2011 11:43, adnane a écrit : >>> >>> Hello >>> >>> Thns every body,but i want know how could i creat datasource in the file >>> entityengine.xml because i notice that this file contain just the >>> defenition >>> of each data base and in the top of file,we precise wich data base we >>> use,so,if i would like use mysql database,sould i change derby and put my >>> sql or there is on other thing to do?? >>> >>> Thnks >> >> Configure your entityengine.xml file: >> put the right definition for your mysql database, and choose for the default >> delegator to use the modified datasource. >> >> https://cwiki.apache.org/confluence/display/OFBTECH/Apache+OFBiz+Technical+Production+Setup+Guide#ApacheOFBizTechnicalProductionSetupGuide-DatabaseSetup >> >> Cheers, >> -- >> Erwan de FERRIERES >> www.nereide.biz >>
