Re: sql standard
| From: | John Lim | Date: | Mon, 24 Jun 2002 11:25:33 +0000 |
| Subject: | Re: sql standard | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-20034@lists.php.net to get a copy of this message | ||
In general, columns are case-insensitive in every relational database I have
tried. However table names might not be.
Regards, John
"Gerard Samuel" <gsam@trini0.org> wrote in message
news:3D168EC6.3040106@trini0.org...
> Hope someone can confirm this.
> I was moving a mysql dump to postgresql, and I had 2 tables with MiXeD
> upper/lower case letters, that
> got converted to lowercase. I found a discussion that sql
> column/table/database names should be lowercase.
> Just trying to keep in line with a standard.
> Thanks
>
> --
> Gerard Samuel
> http://www.trini0.org:81/
> http://dev.trini0.org:81/
>
>