MySQL Bugs: #57636: Script converted to cp850 on load got truncated

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:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.29CE	OS:	Windows (7)
Assigned to:	Alfredo Kojima	CPU Architecture:	Any

Description:
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?

Thank you for the bug report. Could you please provide the output of Help_>System Info. Thanks in advance.

This is the file I try to read in WB

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

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.094.001.005.031149
Video Memory: 262144 KB
Current user language: Français (Canada)

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.

fixed

marked bug #55500 as a duplicate

fix confirmed in repository

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.