>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!
Christian Isberner
Software Consultant