>When creating tables, I've realised that MaxDB has converted
>all of my lower
>case table and column names to upper case.
>
>I know that there is a way around this of doing "SELECT field1
>AS 'field1',
>field2 AS 'field2' FROM mytable as 'mytable'", but this seems
>rather clumsy
>and I wondered if there was any setting that could be changed
>so that table
>and column names can be lower case by default.
You can't get lower case identifiers by default. But you can specify
lower case or mixed case identifiers when using double quotes:
CREATE TABLE "MixedCase" ("lowercase" VARCHAR (20), "on/off" BOOLEAN)
Daniel Dittmar
--
Daniel Dittmar
SAP Labs Berlin
[EMAIL PROTECTED]
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
