** Description changed: + I submited this bug in: + http://www.openoffice.org/issues/show_bug.cgi?id=108319 + Binary package hint: openoffice.org-base I use sun mysql native connetcor to connect my openoffice.org base to mysql server. When I use forms to enter or view data, textboxes without text length limit (means value set to 0), text in forms is limited so some characters, in different fields the limit is different, but it's not the field limit set in mysql database. Temporary solution: set textbox length in form manually. This problem does not appear, when openoffice.org connects with database through odbc. ProblemType: Bug Architecture: i386 Date: Mon Jan 4 11:09:19 2010 DistroRelease: Ubuntu 9.10 NonfreeKernelModules: nvidia Package: openoffice.org-core 1:3.1.1-5ubuntu1 ProcEnviron: - PATH=(custom, no user) - LANG=pl_PL.UTF-8 - SHELL=/bin/bash + PATH=(custom, no user) + LANG=pl_PL.UTF-8 + SHELL=/bin/bash ProcVersionSignature: Ubuntu 2.6.31-17.54-generic SourcePackage: openoffice.org Uname: Linux 2.6.31-17-generic i686
** Description changed: I submited this bug in: http://www.openoffice.org/issues/show_bug.cgi?id=108319 Binary package hint: openoffice.org-base - I use sun mysql native connetcor to connect my openoffice.org base to mysql server. - When I use forms to enter or view data, textboxes without text length limit (means value set to 0), text in forms is limited so some characters, in different fields the limit is different, but it's not the field limit set in mysql database. + - Let's say I have a table `Users` in mysql database. I have two columns, `Id` which is Int type and `Username` which is VARCHAR(255). + - I have OpenOffice that uses Sun Mysql Native Connector. + - I create new form with wizard, open it to enter data and in textbox showing `Username` column I can enter only 7 letters. + - In editing mode I see the length of textbox is set to 0. + - I manually define the length to 255 in editing mode of form, now I can enter 255 letters in this textbox in form. + - I open this table in OpenOffice Base, I can enter in `Username` column 255 letters, here everything is ok. - Temporary solution: set textbox length in form manually. + So, probably Openoffice (or rather the native mysql connector) + improperly reads the defined column length from the database, only in + forms. - This problem does not appear, when openoffice.org connects with database - through odbc. + Please note this value is read properly, when I use ODBC driver. ProblemType: Bug Architecture: i386 Date: Mon Jan 4 11:09:19 2010 DistroRelease: Ubuntu 9.10 NonfreeKernelModules: nvidia Package: openoffice.org-core 1:3.1.1-5ubuntu1 ProcEnviron: PATH=(custom, no user) LANG=pl_PL.UTF-8 SHELL=/bin/bash ProcVersionSignature: Ubuntu 2.6.31-17.54-generic SourcePackage: openoffice.org Uname: Linux 2.6.31-17-generic i686 -- text box length limit in base form with native mysql connector https://bugs.launchpad.net/bugs/502885 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
