List:Commits« Previous MessageNext Message »
From:tony.bedford Date:January 11 2011 1:10pm
Subject:svn commit - mysqldoc@docsrva: r24768 - trunk/refman-common
View as plain text  
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-commontony.bedford11 Jan