> >
> > >-Anders
> >
> > Hi,
> >
> > The field content in the SQl table is >255.
> > When I import with my syntax I get only the first 255 characters and investigating the cursor shows me the field is type C with length 255
> > When I import with cast (myfield type M) as myField result type C with length 255
> >
> > ========================================================
> >
> > >Carlos Alloatti
> >
> > Hi,
> >
> > Your syntax is basicly same as mine. In my case a no conversion into a VFP memo field. Only 255 characters.
> >
> > I suppose there is something else definitely wrong in my approach will investigate further. This thing is driving me crazy.
> >
> > Best regards,
> >
> > Koen
> >
> > ========================================================
> >
> >
> >
> > >Anil
> >
> > Hi,
> >
> > I don’t know the exact length of the field, this can be upto 5’000 or even 50’000 or only 5. I only know I import just the 1st 255 characters the rest is disregarded.
> > Koen
>
>
> Have u updated your mysql odbc driver? look for latest one it 5.1 something i suppose.
>
> Anil
> (Fox is the solution for almost everything!!)
Anil,

I am using 3.51 connector. What do you think could I install both versions? Do not get into conflict? And what is the advantace over the MySQl Connector/5.1? They are both presented on almost the same page by Sun on http://dev.mysql.com/downloads/connector.

Thanks for guiding me.

Regards,

Koen