#38720 [Opn]: PDO_PGSQL Prepare Bug with the table having Japanese Column Name
| From: | jun at lmns dot biz | Date: | Tue, 05 Sep 2006 09:21:06 +0000 |
| Subject: | #38720 [Opn]: PDO_PGSQL Prepare Bug with the table having Japanese Column Name | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-101751@lists.php.net to get a copy of this message | ||
ID: 38720
User updated by: jun at lmns dot biz
Reported By: jun at lmns dot biz
Status: Open
Bug Type: PDO related
Operating System: Debian Etch
PHP Version: 5.1.6
New Comment:
Sorry.
I use PostgreSQL 8.1.4, Apache 2.0.55 .
Previous Comments:
------------------------------------------------------------------------
[2006-09-05 09:00:52] jun at lmns dot biz
Description:
------------
I wanna use prepare statement with the table having Japanese column
name.
But in executing this sql query, error is occured.
select * from hoge where a = :a and JAPANESE_STRING = :b
PREPARE pdo_pgsql_stmt_xxxxxx AS select * from hoge where a = $1 and
JAPANESE_STRING = :b
ERROR: syntax error at or near ":"
Expected result:
----------------
PREPARE pdo_pgsql_stmt_xxxxxx AS select * from hoge where a = $1 and
JAPANESE_STRING = $2
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=38720&edit=1