Author: tbedford
Date: 2011-01-11 14:10:59 +0100 (Tue, 11 Jan 2011)
New Revision: 24768
Log:
Added note as per bug #51527
Modified:
trunk/refman-common/connector-j.xml
Modified: trunk/refman-common/connector-j.xml
===================================================================
--- trunk/refman-common/connector-j.xml 2011-01-11 11:37:13 UTC (rev 24767)
+++ trunk/refman-common/connector-j.xml 2011-01-11 13:10:59 UTC (rev 24768)
Changed blocks: 1, Lines Added: 46, Lines Deleted: 0; 1676 bytes
@@ -6761,6 +6761,52 @@
</qandaentry>
+ <qandaentry>
+
+ <question>
+
+ <para>
+ Using <literal>useServerPrepStmts=false</literal> and
+ certain character encodings can lead to corruption when
+ inserting BLOBs. How can this be avoided?
+ </para>
+
+ </question>
+
+ <answer>
+
+ <para>
+ When using certain character encodings, such as SJIS,
+ CP932, and BIG5, it is possible that BLOB data contains
+ characters that can be interpreted as control characters,
+ for example, blackslash, '\'. This can lead to corrupted
+ data when inserting BLOBs into the database. There are two
+ things that need to be done to avoid this:
+ </para>
+
+ <orderedlist>
+
+ <listitem>
+ <para>
+ Set the connection string option
+ <literal>useServerPrepStmts</literal> to
+ <literal>true</literal>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Set <literal>SQL_MODE</literal> to
+ <literal>NO_BACKSLASH_ESCAPES</literal>.
+ </para>
+ </listitem>
+
+ </orderedlist>
+
+ </answer>
+
+ </qandaentry>
+
</qandaset>
</section>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r24768 - trunk/refman-common | tony.bedford | 11 Jan |
