#38720 [Asn->Fbk]: PDO_PGSQL Prepare Bug with the table having Japanese Column Name

ID: 38720 Updated by: iliaa@php.net Reported By: jun at lmns dot biz -Status: Assigned +Status: Feedback Bug Type: PDO related Operating System: Debian Etch PHP Version: 5.1.6 Assigned To: wez New Comment: Please try using this CVS snapshot: http://snaps.php.net/php5.2-latest.tar.gz For Windows: http://snaps.php.net/win32/php5.2-win32-latest.zip Previous Comments: ------------------------------------------------------------------------ [2006-09-05 09:21:05] jun at lmns dot biz Sorry. I use PostgreSQL 8.1.4, Apache 2.0.55 . ------------------------------------------------------------------------ [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