Jorge is right... I have seen (and suffered the consequences) it in the past, using Oracle.
[]s Roger On 4/20/06, Jorge Godoy <[EMAIL PROTECTED]> wrote: > > Em Quinta 20 Abril 2006 20:01, Robin Haswell escreveu: > > > I'm not sure if case folding applies to this. All that should be necessary > > is adding backticks (or equivalents - maybe) around table/column names. > > In PostgreSQL if you use quotes you have to use the exact same case that was > used to create the table. If you don't, names will be converted to lower > case. In Oracle if you don't use quotes names will be converted to upper > case. > > If you create a table like this "Test" then you can't access it like "test" or > "TEST" in PostgreSQL, for example. On the other hand, if you create it like > Test, then it will be converted to test and you can access it as test, Test, > TEST, teST, TeST, etc. All without quotes, of course. If you try accessing > it as "Test" (with quotes), it will fail. > > Now, imagine it in an database that is used by several applications in, lets > say, 3 different languages. Several different teams coding, etc. If you > enforce the use of quotes in one of these apps, *all* of them will have to > use quotes to maintain compatibility and there will have to be some internal > documentation on how to name tables and columns. If you don't use quotes, > then it doesn't matter if team A writes "select ThisColumn from TableA" and > team B writes "select thiscolumn from tablea" since both will succeed. > > There is much more to consider than just the presence or absence of quotes, > backticks, etc. here. It is easy to think in a new application used by only > one team but it is a very narrow minded approach to a database that can be > shared by several applications and several teams in different programming > languages. > > -- > Jorge Godoy <[EMAIL PROTECTED]> > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/turbogears -~----------~----~----~----~------~----~------~--~---
