On Jan 16, 2007, at 5:28 PM, Si Chen wrote:
Actually, believe it or not it's for the table names. I ran into problems moving stuff between windows, linux, and os x because the MySQL defaults are different for each one. I thought since that ofbiz can run fine with case-insensitive, it might be better to recommend to everybody to do the case-insensitive setting as a lowest common denominator.
Interesting... gotta love database quirks!I think this is fine. I did a quick search on docs.ofbiz.org for "mysql" and I see mention in a number of pages, but we should really have something like a bunch of database how-tos, in the case a "MySQL How-To" page or something along those lines.
There has been a fair amount of discussion about MySQL lately with a number of different issues that it would be good to address in such a document (if a good best-practice solution exists).
BTW, for anyone reading in: I don't mean to single out MySQL here, and in fact I personally don't recommend that people use MySQL with OFBiz, especially if they need to do anything internationalized or the like, and I have issues with the MySQL licensing policies to some extend, and practices to a large extent. Anyway, my favorite production database for OFBiz is PostgreSQL, just in case anyone is wondering.
-David
smime.p7s
Description: S/MIME cryptographic signature
