Bug #8064 With sjis config, inserting some data into blob column causes "Syntax error"
Submitted: 21 Jan 2005 10:13 Modified: 28 Jan 2005 15:13
Reporter: Shu SATO
Status: Not a Bug
Category:Server Severity:S2 (Serious)
Version:4.0.20 OS:Linux (Redhat ES 3)
Assigned to: Target Version:

File: Maximum allowed size is 500KB.
Description:
Privacy:

If the data you need to attach is more than 500KB, you should create a compressed archive of the data and a README file that describes the data with a filename that includes the bug number (example: bug-data-8064.zip), and use FTP to upload the archive to ftp://ftp.mysql.com/pub/mysql/upload/. Once you have uploaded the file, add a comment to this bug to notify us about it. Note: This directory is unlistable, which means that once you have uploaded your file, you will not be able to see it.

All entries become the exclusive editorial property of Sun Microsystems, Inc.

[31 Jan 2005 6:10] Shu SATO
Simple java client program to reproduce

Attachment: SQLTest06.java (application/octet-stream, text), 2.27 KiB.

[31 Jan 2005 6:12] Shu SATO
Results of 'show variables' in reproduction environment

Attachment: showvars.txt (text/plain), 3.19 KiB.

[31 Jan 2005 8:43] Shu SATO
a patch kindly provided by Hiromichi Mizuno

Attachment: sql_lex.cc.patch (application/octet-stream, text), 763 bytes.

[31 Jan 2005 9:05] Shu SATO
Unit test cases for Hiromichi's patch

Attachment: BlobSJISTest.java (application/octet-stream, text), 19.96 KiB.

[1 Feb 2005 9:30] Shu SATO
A patch for PreparedStatement.java of Connector/J 3.0.16

Attachment: PreparedStatement.java.patch (application/octet-stream, text), 2.82 KiB.