>Hi Christian:
>
>First I haven't change any settins yet.
>
>>That should not happen. Maybe I misunderstood your problem, but can you give me an example whhich query you run and what the cursor contains?
>
>I'm uploading four images.
>
>table.jpg is the remote table (it's really on a web server)
>
>records.jpg are the first records of the mentioned table. I hope you can see they look very nice and proper.
>
>select.jpg are the two instructions I tested.
>
>Cause I tried to use VFP functions and they failed I assume MySQL has a different sintax so I'll have to learn it.
>
>finally cursor.jpg is the result. As you can see "tinytext" converts to memo field. (as text, as fulltext)
>
>I can't believe it but as Juan Perón said: "There's just a truth: Reality"
>
>Thank you.
>
> Héctor

Now I understand your problem:

You need to use those datatypes:

VFP	MySQL

C	CHARACTER(nLength)
N	DECIMAL(nLength,nDecimals)
I	INT
D	DATE
T	TIME
M	MEDIUMTEXT
L	BOOL

That should work!