Changeset 2432

Timestamp:

04/18/2008 04:02:05 AM

Author:

tof

Message:

Implemented #800

Files:

• trunk/HISTORY (modified) (1 diff)
• trunk/framework/Data/TDbConnection.php (modified) (6 diffs)

trunk/HISTORY

@@ -39 +39 @@
-ENH: Ticket#757 - TDateFormat and TNumberFormat now implement IDataRenderer (Qiang)
-ENH: Ticket#783 - Added date/time type support to soap implementation (Hongliang)
+ENH: Ticket#800 - Added database connection charset for MySql (donkee)
-ENH: Active Record supports multiple foreign references of the same table (Wei)
-ENH: Added TDbCommand.queryColumn() (Qiang)

trunk/framework/Data/TDbConnection.php

@@ -28 +28 @@
- * and {@link setPassword Password}.
- *
+ * Since 3.1.2, the connection charset can be set (for MySQL databases only) using the {@link setCharset Charset} property.
+ * 
- * The following example shows how to create a TDbConnection instance and establish
- * the actual connection:
@@ -83 +85 @@
-        private $_username='';
-        private $_password='';
+        private $_charset='';
-        private $_attributes=array();
-        private $_active=false;
@@ -93 +96 @@
-         * instance is created. Set {@link setActive Active} property to true
-         * to establish the connection.
+         * Since 3.1.2, you can set the charset for MySql connection
+         * 
-         * @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
-         * @see http://www.php.net/manual/en/function.PDO-construct.php
-         */
-
+, $charset=''
-        {
-                $this->_dsn=$dsn;
-                $this->_username=$username;
-                $this->_password=$password;
+                $this->_charset=$charset;
-        }
-
@@ -162 +169 @@
-                                $this->_pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
-                                $this->_active=true;
+                                $this->setConnectionCharset();
-                        }
-                        catch(PDOException $e)
@@ -180 +188 @@
-        }
-
+        /*
+         * Set the database connection charset.
+         * Only MySql databases are supported for now. 
+         * @since 3.1.2
+         */
+        protected function setConnectionCharset()
+        {
+                if ($this->_charset === '' || $this->_active === false)
+                        return;
+                switch ($this->_pdo->getAttribute(PDO::ATTR_DRIVER_NAME))
+                {
+                        case 'mysql':
+                                $stmt = $this->_pdo->prepare('SET CHARACTER SET ?');
+                                $stmt->execute(array($this->_charset));
+                        break;
+                }
+        }
+                
-        /**
-         * @return string The Data Source Name, or DSN, contains the information required to connect to the database.
@@ -229 +255 @@
-        }
-
+        /**
+         * @return string the charset used for database connection. Defaults to emtpy string.
+         */
+        public function getCharset ()
+        {
+                return $this>_charset;
+        }
+        
+        /**
+         * @param string the charset used for database connection
+         */
+        public function setCharset ($value)
+        {
+                $this->_charset=$value;
+                $this->setConnectionCharset();
+        }
+        
-        /**
-         * @return PDO the PDO instance, null if the connection is not established yet