As I said if we create table with “table” Then select would be like select * from “table” and not select * from table and same for every column where by default it makes table as TABLE and select * from table or Table or TABLE everything works fine .
Regards > On 18-Feb-2020, at 7:15 PM, Ilya Kasnacheev <[email protected]> wrote: > > > 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 >>> >>>
