svn: /phpdoc/en/trunk/reference/pdo_mysql/ reference.xml
| From: | Adam Harvey | 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>