Re: Uppercase field names not found

On Mon, 2002-06-17 at 20:25, Scot Wilcoxon wrote:
> I've seen a few comments of people encountering this problem, but not
> yet a solution:
>
> Upper case field names in commands are forced to lower case and then not
> found.
>
> I was able to create a table with a field called "ABC".
>
> "SELECT ABC FROM mytable;"
> emits the error
> "no such attribute or function abc"

If it is possible, you will have a much easier time if you change you
schema to use case folded names

EG:
CREATE TABLE Foo ( ... )
rather than: CREATE TABLE "Foo" ( ... )

otherwise.. You will need to change your code to quote all references to
the name:

EG:
$q = 'SELECT * from "Foo"';

If you don't put ["]'s around the object identifier, it gets case folded
to lower case.

--
David Stanaway