Thanks for the link. I have made a form by hand and I have the same problem => it's not an autopilot problem. I think it's a MyODBC problem.
On the french list, Tony Galmiche has just reproduced the problem both on Windows and Linux. Alex Thurgood has forwarded the issue to the [EMAIL PROTECTED] list. Anyway I forward your information to the french list. Thanks. Henri. Le Jeudi 3 FÃvrier 2005 14:35, G. Roderick Singleton a ÃcritÂ: > On Thu, 2005-02-03 at 09:46 +0100, henri 3moulins wrote: > > Hi, > > > > I have a "mediumtext" field in a MySQL table. I use the autopilot > > generated form. > > > > Using the form, I can save a "long" text (for example 7000 characters) in > > the base; I can browse the base and read this text. > > > > BUT, when I edit, modify and save this text with the form, it is > > truncated at 2049 characters ! > > > > The max length of this field is automatically set at -1 by the form > > autopilot. It doesn't change anything to set it at 30000 for example. > > > > What am I doing wrong ? > > (I am newbie with MySQL but when I do this text modification with > > phpMySQL everything is ok => I don't think the problem is with MySQL) > > > > > > Any idea will be extremely appreciated ! ( .... I'll post the solution on > > the french list : it remained silent on this issue ....) > > > > Thanks in advance. > > > > Henri. > > > > OOo 1.1.4 > > Suse 9.2 > > MySQL 4.0.21-4.2 > > MyODBC-unixODBC-3.51.07-3 > > unixODBC-2.9.9-4 > > > > > > PS : if someone wish to make a quick test, thre is the following script > > to generate a 7000 characters text : > > > > #! /bin/bash > > i=0 > > while [ $i -lt 7000 ] ; do > > i=$((i+1)) > > echo -n "x" >> 7000charText > > done > > Check http://www.openoffice.org/issues/show_bug.cgi?id=31048 as this may > be your problem. You could also try 1.9 which has the problem fixed. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
