Does this also work with ERTags and Attachments? 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 <[email protected]>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 <[email protected]> > 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 ([email protected]) > >>>>> Help/Unsubscribe/Update your Subscription: > >>>>> https://lists.apple.com/mailman/options/webobjects-dev/pyu%40mac.com > >>>>> > >>>>> This email sent to [email protected] > >>> > >>> > >>> _______________________________________________ > >>> Do not post admin requests to the list. They will be ignored. > >>> Webobjects-dev mailing list ([email protected]) > >>> Help/Unsubscribe/Update your Subscription: > >>> > https://lists.apple.com/mailman/options/webobjects-dev/probert%40macti.ca > >>> > >>> This email sent to [email protected] > >> > > > > > > _______________________________________________ > > Do not post admin requests to the list. They will be ignored. > > Webobjects-dev mailing list ([email protected]) > > Help/Unsubscribe/Update your Subscription: > > > https://lists.apple.com/mailman/options/webobjects-dev/kelleherk%40gmail.com > > > > This email sent to [email protected] > > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected]) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/james%40jimijon.com > > This email sent to [email protected] > >
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
