diff options
Diffstat (limited to 'framework/Data/TDbConnection.php')
| -rw-r--r-- | framework/Data/TDbConnection.php | 11 |
1 files changed, 8 insertions, 3 deletions
diff --git a/framework/Data/TDbConnection.php b/framework/Data/TDbConnection.php index 08a8695a..2f5a0358 100644 --- a/framework/Data/TDbConnection.php +++ b/framework/Data/TDbConnection.php @@ -27,7 +27,9 @@ Prado::using('System.Data.TDbCommand'); * specifying {@link setConnectionString ConnectionString}, {@link setUsername Username}
* and {@link setPassword Password}.
* - * Since 3.1.2, the connection charset can be set (for MySQL databases only) using the {@link setCharset Charset} property. + * Since 3.1.2, the connection charset can be set (for MySQL and PostgreSQL databases only) + * using the {@link setCharset Charset} property. The value of this property is database dependant. + * e.g. for mysql, you can use 'latin1' for cp1252 West European, 'utf8' for unicode, ... *
* The following example shows how to create a TDbConnection instance and establish
* the actual connection:
@@ -100,7 +102,7 @@ class TDbConnection extends TComponent * @param string The Data Source Name, or DSN, contains the information required to connect to the database.
* @param string The user name for the DSN string.
* @param string The password for the DSN string. - * @param string Charset used for DB Connection (MySql only). If not set, will use the default charset of your database server
+ * @param string Charset used for DB Connection (MySql & pgsql only). If not set, will use the default charset of your database server
* @see http://www.php.net/manual/en/function.PDO-construct.php
*/
public function __construct($dsn='',$username='',$password='', $charset='')
@@ -200,9 +202,12 @@ class TDbConnection extends TComponent { case 'mysql': $stmt = $this->_pdo->prepare('SET CHARACTER SET ?'); - $stmt->execute(array($this->_charset)); + break; + case 'pgsql': + $stmt = $this->_pdo->prepare('SET client_encoding TO ?'); break; } + $stmt->execute(array($this->_charset)); } /**
|