You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by Abhay Gupta <ab...@avissol.com> on 2020/02/18 08:05:59 UTC
Column name in lower case
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
Re: Column name in lower case
Posted by Abhay Gupta <ab...@avissol.com>.
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 <il...@gmail.com> 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 <is...@apache.org>:
>> 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 <ab...@avissol.com> 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
>>>
>>>
Re: Column name in lower case
Posted by Ilya Kasnacheev <il...@gmail.com>.
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 <is...@apache.org>:
> 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 <ab...@avissol.com> 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
>>
>>
>>
>
Re: Column name in lower case
Posted by Igor Sapego <is...@apache.org>.
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 <ab...@avissol.com> 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
>
>
>