Can read but not save binary data (e.g. BYTEA) in version 1.1.11

[karmakaze]

When reading a BYTEA column, it is a PHP 'resource' type which can be read like a file.

When saving such a column, an escaped value (such as '\x9f319004ad45' can be set in the case of PostgreSQL) and it will be translated to a resource for PDO to write. When it goes to write it however, it gets cast to a string somewhere along the line and ends up writing data like 'Resource #68' to the bytea column instead of the intended binary data.

The following is a patch to CDbConnection.php (diff on tag 1.1.11) which corrects the problem:

diff --git a/framework/db/CDbConnection.php b/framework/db/CDbConnection.php
index beff103..7ba01de 100644
--- a/framework/db/CDbConnection.php
+++ b/framework/db/CDbConnection.php
@@ -587,6 +587,7 @@ class CDbConnection extends CApplicationComponent
                        'boolean'=>PDO::PARAM_BOOL,
                        'integer'=>PDO::PARAM_INT,
                        'string'=>PDO::PARAM_STR,
+                       'resource'=>PDO::PARAM_LOB,
                        'NULL'=>PDO::PARAM_NULL,
                );
                return isset($map[$type]) ? $map[$type] : PDO::PARAM_STR;