Bug #57636 Script converted to cp850 on load got truncated
Submitted: 21 Oct 2010 20:15 Modified: 6 Jan 2011 12:43
Reporter: Dev Staff Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.29CE OS:Windows (7)
Assigned to: Alfredo Kojima CPU Architecture:Any

[21 Oct 2010 20:15] Dev Staff
Cannot open big script files. I used ultraedit to manipulate the file then I tried to open and execute in Workbench.

How to repeat:
Open a file in workbench that is 205MB

Suggested fix:
Let it open big files?
[22 Oct 2010 10:20] MySQL Verification Team
Thank you for the bug report. Could you please provide the output of Help_>System Info. Thanks in advance.
[11 Nov 2010 3:07] Yves Archambault
This is the file I try to read in WB

Attachment: Bug 57636 example.zip (application/zip, text), 8.06 KiB.

[11 Nov 2010 3:16] Yves Archambault
I have a similar problem with a script file of 34k.
The sql script is generated from a DBF transfer to a script file.
I then use File, open sql script, change Latin1 to cp850 when system ask.
The file is then read but depending on his size, one or more caracters are lost.
I have include an example file as 'Bug 57636 example.zip'
I have check with an Hex editor and there is no special caracter where it stop the importation.
The last line (140) have a red x and look like this.
«INSERT INTO `fmr1ma` VALUES('1017177', "", 'T14761', 'T14761', "", '2009', 'F', "", "", "", 'AH', "", "", NULL, 'SA', 'NA', 'ZI', 'I', NULL, '6S', '6S', 'ZI', 'F', 0, "", "", "", "", "", '2009', 'BOURASSA', 'Sylvie', 'Mme.', '2279, boulevard du Carmel', "", 'TROIS-RIVIERES', 'Québ»
It always stop at the same place in this file script import.

MySQL Workbench CE for Windows version 5.2.29
Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE
Cairo Version: 1.8.8
Rendering Mode: OpenGL is available on this system, so OpenGL is used for rendering.
OpenGL Driver Version: 2.1.8787
OS: Microsoft Windows 7 Home Premium Edition (build 7600), 64-bit
CPU: 2x AMD Turion(tm) X2 Dual-Core Mobile RM-74, 3.8 GiB RAM
Video adapter info:
Adapter type: ATI Radeon HD 3200 Graphics 
Chip Type: ATI display adapter (0x9612)
BIOS String: BK-ATI VER010.
Video Memory: 262144 KB
Current user language: Français (Canada)
[13 Nov 2010 1:51] Alfredo Kojima
This is a duplicate of bug #55312. However, the problem reported by Yves is a different one
and I was able to repeat it in Mac.

I am recycling this report for Yves problem and updating the Synopsis accordingly.
[13 Nov 2010 1:55] Alfredo Kojima
[17 Nov 2010 18:48] Alfredo Kojima
marked bug #55500 as a duplicate
[8 Dec 2010 20:19] Johannes Taxacher
fix confirmed in repository
[6 Jan 2011 12:43] Tony Bedford
An entry has been added to the 5.2.31 changelog:

A script file that was converted to cp850 on loading into the SQL Editor was truncated.