Set the option "Don't optimise column width"
I assume this will fix it - it does with Power++ datawindows.
----------
> From: Christian Mack <Mack@stripped>
> To: Richard Farmer <farmerr@stripped>
> Cc: myodbc@stripped
> Subject: Re: data truncated
> Date: Friday, May 07, 1999 6:11 PM
>
> Richard Farmer wrote:
> >
> > Hi,
> > I am having problems using mysql with powerbuilder. Whenever I try to
> > do a retrieve from the database with an argument i get a data truncated
> > error. Does anyone know why this is happening?
> >
> > Richard Farmer
> > ARL
>
> Hi Richard
>
> Not sufficient infos!!!
> Give an example query!
> Give us the table structure!
> Give us your MyODBC options!
>
> Perhaps the rows you get back are too wide.
> Then you have to set the 'Read options from C:\my.cnf' option and set a
larger max_allowed_packet for MyODBC.
>
> Perhaps you get too many rows back.
> Then you have to use the option 'Allow BIG results'.
>
> Tschau
> Christian
>
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail myodbc-thread216@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail myodbc-unsubscribe@stripped instead.
