Home > mailing lists

Thread: Case Sensitive problem

Case Sensitive problem

From

"DenBaguse MasRodjie"

Date:

06 October 2003, 14:26:02

Thank's a lot for help me to convert from MySQL.

But i have a problem again.

Can i configure ODBC to return case-sensitive?

Cause i have an error for query like :

"SELECT * FROM afSHIPPER"

ERROR: Relation "afshipper" doesn't exists

Anyone help my problem?

Thank's

Roji

Re: Case Sensitive problem

From

"Dave Page"

Date:

06 October 2003, 14:40:31

Hi,

PostgreSQL folds unquoted identifiers to lowercase. Try:

SELECT * FROM "afSHIPPER"

Regards, Dave.

-----Original Message-----
From: DenBaguse MasRodjie [mailto:roji@mail15.com]
Sent: 06 October 2003 15:28
To: pgsql-odbc@postgresql.org
Subject: [ODBC] Case Sensitive problem

Thank's a lot for help me to convert from MySQL.
But i have a problem again.
Can i configure ODBC to return case-sensitive?
Cause i have an error for query like :
"SELECT * FROM afSHIPPER"
ERROR: Relation "afshipper" doesn't exists
Anyone help my problem?

Thank's

Roji