On 1/24/02 8:12 AM, "Geoffrey Talvola" <[EMAIL PROTECTED]> wrote:

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

Oracle and PostgreSQL are not case preserving. PostgreSQL will bash to
lowercase, Oracle will bash to uppercase.

However, if you put your table name and column names in quotations, Oracle
and PostgreSQL will preserve case.  I.e.: create table "FooBar" ( ...

Rolf



_______________________________________________
Webware-discuss mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/webware-discuss

Reply via email to