PSQLODBC case insensitive

------=_Part_22132_25025706.1170968409452
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi folks

I'm accessing my PostgreSQL server from Windev (a french development
tool) through the ODBC driver. I created the tables without quotes, so it
doesnt if I execute this:

SELECT column FROM table
or this:
SELECT CoLuMn FROM tAbLe

But when I put the tables and columns names in Windev on lowercase I can
access without problems. If I change one or more letters to uppercase I get
an error.
Seems like the driver is building the statements like this:

SELECT "CoLuMn" FROM "tAbLe"

So the server cant find the tables and columns. Thas what I think. I'm I
wrong? If not, is that a way that I can make the ODBC driver build the
statements without quotes?


Sorry for my bad English.

Antonio Carlos,
Itabuna - BA - Brasil

------=_Part_22132_25025706.1170968409452
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Re: PSQLODBC case insensitive

> I'm accessing my PostgreSQL server from Windev (a french development
> tool) through the ODBC driver. I created the tables without quotes, so it

Where have you created the tables? Could you try create new one with
logs enabled to see what SQL command is executed?

> doesnt if I execute this:
>
> SELECT column FROM table
> or this:
> SELECT CoLuMn FROM tAbLe

Sorry, I don't understand what's the problem.

> But when I put the tables and columns names in Windev on lowercase I can
> access without problems. If I change one or more letters to uppercase I get
> an error.
> Seems like the driver is building the statements like this:
>
> SELECT "CoLuMn" FROM "tAbLe"

What does psqlodbc.log or mylog say (SQL statements)?

Regards,

Luf

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

Re: PSQLODBC case insensitive

------=_Part_38763_19699836.1171112372654
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I was wrong, Im not accessing through the ODBC driver, Im using ODBC access
via OLEDB.
I did an example accessing directly through the ODBC driver and it worked
fine.
I guess it is the OLEDB that is making the confusion.

Sorry for the trouble and for my bad English again.
Thanks anyway

Antonio Carlos,
Itabuna - BA - Brasil

------=_Part_38763_19699836.1171112372654
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I was wrong, Im not accessing through the ODBC driver, Im using ODBC access via OLEDB.
I did an example accessing directly through the ODBC driver and it worked fine.
I guess it is the OLEDB that is making the confusion.


Sorry for the trouble and for my bad English again.
Thanks anyway