PHP 4.0 Bug #8317: postgresql table uppercase field name
| From: | yamin at 126 dot com | Date: | Tue, 19 Dec 2000 01:29:30 +0000 |
| Subject: | PHP 4.0 Bug #8317: postgresql table uppercase field name | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-41815@lists.php.net to get a copy of this message | ||
From: yamin@126.com
Operating system: redhat 6.2
PHP version: 4.0.3
PHP Bug Type: PostgreSQL related
Bug description: postgresql table uppercase field name
Hi:
I use Redhat OS, postgresql database and PHP build my website, I import datas to postgresql, and all
the table field name is uppercase like the follwing:
Attribute | Type | Modifier
-----------+-------------+----------
WHFILE | varchar(10) |
WHFLDI | varchar(10) |
WHFLDE | varchar(10) |
WHIBO | integer |
WHFLDB | integer |
WHFLDD | smallint |
WHFLDP | smallint |
WHFTXT | varchar(50) |
WHFLDT | varchar(1) |
psql query like following can do:
movextest=# select "WHFILE", "WHFLDI","WHFTXT" from cfiffd00 where
"WHFILE" like upper('%mpccid%');
but in PHP the query can not run! why? and how to run like this condition?
--
Edit Bug report at: http://bugs.php.net/?id=8317&edit=1