They aren't case issues.  It is called case sensitivity.  Real RDBMS are
case sensitive.

You need to give us a little bit better example of your code to be able to
help you.  Based on what you showed us, it won't work because you don't have
quotes around your text.

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
----- Original Message -----
From: "Steve Hache" <shache@s...>
To: "professional php" <pro_php@p...>
Sent: Monday, December 10, 2001 7:09 PM
Subject: [pro_php] PHP and POSTGRE


>
> Hello.
>
> I am having trouble with uppcase/lowercase in POSTGRESQL while using a PHP
> front end.
>
> The query that I am using is as follows:
> SELECT id from tables where site_code = 14YONGE
>
> The query comes back fine when types directly into PSQL, but when used
from
> the PHP front end, it tells me that there is no entry in the table for
> 14yonge. Obviously there is a case problem. I recall reading that POSTGRE
> has some case issues.
>
> Anyone encounter this problem before and come up with a solution.
>
> Thanks in advance.
>
> Steve Hache
>
>