Hello!
Have you tried using case-sensitive column names, such as
CREATE TABLE "table" ("lowercaseid" INT PRIMARY KEY, "mixedCaseVal"
VARCHAR);
Maybe it will help with your use case.
Regards,
--
Ilya Kasnacheev
вт, 18 февр. 2020 г. в 15:09, Igor Sapego <[email protected]>:
> There are no such way in ODBC, but maybe SQL guys can suggest
> some solution here.
>
> Anyway this is weird, as software that uses ODBC can actually query
> ODBC driver for the case of the returned SQL symbols, and our driver
> clearly states that it uses upper case.
>
> Best Regards,
> Igor
>
>
> On Tue, Feb 18, 2020 at 11:06 AM Abhay Gupta <[email protected]> wrote:
>
>> Hi,
>>
>>
>>
>> I am using UNIX ODBC and since create table command causes column name in
>> UPPER case , and so SQLDescribeCol returns column name in UPPER case .
>>
>>
>>
>> Some of the application servers like Asterisk which checks the column
>> name breaks as they expect the column name to be lower case . Is there a
>> way to create column name in lower case and run the query on them without
>> using double quotes .
>>
>>
>>
>> Regards,
>>
>>
>>
>> Abhay Gupta
>>
>>
>>
>
