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 -~----------~----~----~----~------~----~------~--~---
