To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90884 Issue #|90884 Summary|possible dataloss when using long varchar Component|Database access Version|OOo 2.4.0 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|michaelstrobel
------- Additional comments from [EMAIL PROTECTED] Thu Jun 19 13:21:23 +0000 2008 ------- Try the following using Base and the SDBC-JDBC driver with MySQL or Ingres database: Copy a string that exceeds 65535 characters into a long varchar column. The string is cut and a warning is displayed, which is good, but surprisingly the string is cut to noticeably less than 65535 characters. The exact number of characters to which the string is cut seems depend on how long the string you try to insert is. Then fill the long varchar column with additional characters until you reach 65535 characters or more and click the save button. Now close the table and reopen it. You will see that the value you edited before is erased. I think this is be a really bad bug, as it might destroy the users data. --------------------------------------------------------------------- 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]
