On Thursday January 24, 2002 12:46 am, [EMAIL PROTECTED] wrote: > I'm trying to decide whether to use the variable naming conventions that > Webware uses in an RDBMS. By convention, we use "variableNamesLikeThis" in > Python because this is what Webware uses too (trying to keep jarring style > changes to a minimum). > > The problem is of course, that SQL isn't case sensitive, at least as far as > table and column names are concerned. So, using the Webware convention when > naming tables, columns, etc. will result in rather unreadable > "tableandcolumnnameslikethis". For this reason, most people use underscores > to get "table_and_column_names_like_this". > > I guess I'm a bit fussy in trying to avoid a jarring shift in naming > conventions between SQL and Python, but I can't think of a nicer > compromise. Is there a way out of all this ugliness? > > ...Edmund. >
SQL may not be case-sensitive, but all SQL databases I've used (Access, MS SQL Server, MySQL) are in fact case-preserving. So you can name your tables and columns FooBar and use them in your code as FooBar, and they will show up in the SQL tools as FooBar. Sort of like the Windows filesystem, or Visual Basic code. - Geoff _______________________________________________ Webware-discuss mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/webware-discuss
