On Jul 16, 2012, at 12:49 PM, James Cicenia wrote: > Does this also work with ERTags and Attachments?
Works for me. > I converted a database that was also all lowercase and those tables got added > redundantly with camel case. I basically copied the data from the lower case > to the upper case tables and it worked, but in the future, I would prefer not > to do that. > > Regards > James > > On Mon, Jul 16, 2012 at 11:27 AM, Kieran Kelleher <kelleh...@gmail.com> wrote: > This is the setting I use in my.cnf (read the comments, especially last line > before trying this) > > <snip> > # If set to 0, table names are stored as specified and comparisons are case > # sensitive. If set to 1, table names are stored in lowercase on disk and > # comparisons are not case sensitive. If set to 2, table names are stored as > given > # but compared in lowercase. This option also applies to database names and > table > # aliases. For additional information, see Section 8.2.2, “Identifier Case > # Sensitivity”. > # You should not set this variable to 0 if you are running MySQL on a system > that > # has case-insensitive file names (such as Windows or Mac OS X). If you set > this > # variable to 0 on such a system and access MyISAM tablenames using different > # lettercases, index corruption may result. On Windows the default value is > 1. On > # Mac OS X, the default value is 2. > # If you are using InnoDB tables, you should set this variable to 1 on all > # platforms to force names to be converted to lowercase. Prior to MySQL > Cluster > # NDB 6.3.35, MySQL Cluster NDB 7.0.15, and MySQL Cluster NDB 7.1.4, this is > also > # true for tables using the NDB storage engine. > # KK: We want setting of 1 for innodb and linux compatability > # KK: Do not change this to 1 without first changing the actual table names > to lower case first > lower_case_table_names = 1 > </snip> > > > Also here is a simple *quick hack* script for converting a database's tables > all to lowercase names. Understand it and take necessary precautions before > using: > > > > > > > HTH, Kieran > > > On Jul 16, 2012, at 9:48 AM, Jean Pierre Malrieu wrote: > > > Thank you both. It works. > > Now discovering that on UNIX, mysql table name are case sensitive... Grrrr! > > > > Le 16 juil. 2012 à 15:00, Pascal Robert a écrit : > > > >> > >> Le 2012-07-16 à 08:58, Jean Pierre Malrieu a écrit : > >> > >>> Meaning you add it directly in the "Libraries" folder and ant build picks > >>> it up? > >> > >> Yes. > >> > >>> Le 16 juil. 2012 à 14:26, Paul Yu a écrit : > >>> > >>>> I embed the jdbc library in my app bundle, > >>>> > >>>> Sent from my iPad > >>>> > >>>> On Jul 16, 2012, at 8:07 AM, Jean Pierre Malrieu <jp.malr...@free.fr> > >>>> wrote: > >>>> > >>>>> Hi, > >>>>> > >>>>> I am trying my first deployment on LINUX, and thanks to the > >>>>> instructions in the wiki, things seem to work more or less (application > >>>>> deployed and launched). > >>>>> But I have got an exception (cannot obtain database channel) when > >>>>> trying to talk to mysql. > >>>>> I have installed the jdbc driver, but how do I tell the app where to > >>>>> find it? > >>>>> > >>>>> TIA > >>>>> > >>>>> JPM > >>>>> _______________________________________________ > >>>>> Do not post admin requests to the list. They will be ignored. > >>>>> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) > >>>>> Help/Unsubscribe/Update your Subscription: > >>>>> https://lists.apple.com/mailman/options/webobjects-dev/pyu%40mac.com > >>>>> > >>>>> This email sent to p...@mac.com > >>> > >>> > >>> _______________________________________________ > >>> Do not post admin requests to the list. They will be ignored. > >>> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) > >>> Help/Unsubscribe/Update your Subscription: > >>> https://lists.apple.com/mailman/options/webobjects-dev/probert%40macti.ca > >>> > >>> This email sent to prob...@macti.ca > >> > > > > > > _______________________________________________ > > Do not post admin requests to the list. They will be ignored. > > Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) > > Help/Unsubscribe/Update your Subscription: > > https://lists.apple.com/mailman/options/webobjects-dev/kelleherk%40gmail.com > > > > This email sent to kelleh...@gmail.com > > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/james%40jimijon.com > > This email sent to ja...@jimijon.com > > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/kelleherk%40gmail.com > > This email sent to kelleh...@gmail.com
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
