svn: /phpdoc/en/trunk/reference/pdo_mysql/ reference.xml

From: Date: Tue, 14 Jun 2011 15:08:42 +0000
Subject: svn: /phpdoc/en/trunk/reference/pdo_mysql/ reference.xml
Groups: php.doc.cvs 
Request: Send a blank email to doc-cvs+get-8268@lists.php.net to get a copy of this message
aharvey Tue, 14 Jun 2011 15:08:42 +0000 Revision: http://svn.php.net/viewvc?view=revision&revision=312154 Log: Per a suggestion from Philip on IRC, show how to work around the charset DSN parameter being ignored with pdo_mysql before PHP 5.3.6, based on a user note by Davy Defaud. Changed paths: U phpdoc/en/trunk/reference/pdo_mysql/reference.xml Modified: phpdoc/en/trunk/reference/pdo_mysql/reference.xml =================================================================== --- phpdoc/en/trunk/reference/pdo_mysql/reference.xml 2011-06-14 14:40:03 UTC (rev 312153) +++ phpdoc/en/trunk/reference/pdo_mysql/reference.xml 2011-06-14 15:08:42 UTC (rev 312154) @@ -91,8 +91,35 @@ <term><constant>charset</constant></term> <listitem> <para> - The character set (since PHP 5.3.6). + The character set. </para> + <para> + Prior to PHP 5.3.6, this element was silently ignored. The same + behaviour can be replicated with the + <constant>PDO::MYSQL_ATTR_INIT_COMMAND</constant> driver option, as + the following example shows. + </para> + <para> + <example> + <title> + Setting the connection character set to UTF-8 prior to PHP 5.3.6 + </title> + <programlisting role="php"> +<![CDATA[ +<?php +$dsn = 'mysql:host=localhost;dbname=testdb'; +$username = 'username'; +$password = 'password'; +$options = array( + PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8', +); + +$dbh = new PDO($dsn, $username, $password, $options); +?> +]]> + </programlisting> + </example> + </para> </listitem> </varlistentry> </variablelist>

« previous php.doc.cvs (#8268) next »