Обсуждение: PSQLODBC case insensitive
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
> 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
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
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