To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=42296 Issue #:|42296 Summary:|MySql forms and MEDIUMTEXT field : truncated text on |save of data Component:|Database access Version:|OOo 1.1.4 Platform:|PC URL:| OS/Version:|Linux Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P2 Subcomponent:|none Assigned to:|msc Reported by:|henri3m
------- Additional comments from [EMAIL PROTECTED] Wed Feb 9 00:16:16 -0800 2005 ------- MySql forms and MEDIUMTEXT field : data loss Confirmed on : - OOo 1.1.4 ; Suse 9.2; MySql 4.0.21-4.2; MyODBC-unixODBC-3.51.07-3; unixODBC-2.9.9-4 - OOo 1.1.4 ; Win NT; MyOBDC 3.51.9 To reproduce : 1. You need a MySQL table with a MEDIUMTEXT field (maximum length 2^24 â 1 characters) 2. A form connected to this field : - The form can be "hand made" (no need to use the form wizard.) - The MAX TEXT LENGTH can be set to -1 (i.e. adaptable as a function of the length of the string to be entered) or any big value (20,000 for example). 3. Enter a "long" record in this field (for example : 7000 characters) 4. Browse the table => you can reread the data from the form. 5. Edit and modify the "long" text 6. Save the modified text in the database => The text gets truncated to 2049 characters : data loss ! Notes : - The only way around this is to create a new record and enter the modified data, then delete the original record. - If I update the data via phpMySQL the problem does not occur. - I set P2 priority because of the data loss (cf. issue guidelines) Please don't hesitate to ask for further info. Henri --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
