I remember that there was a problem with migration the memo fields van dbase
3 or 4 to xbase dbf. Does anyone remember the solution. Cannot find it
anymore on the forum. Thanks in advance

Hi Leander

What kind of problems?

Very Best Regards

João Pedro Machado de Sousa

"Joo Pedro Machado de Sousa" <macsousa@maso.co pt> wrote in message 
news:3jhu6vixs7em$.4zfqvjzu5xn7$.dlg@40tude.net...
> Hi Leander
>
> What kind of problems?
>
> Very Best Regards
>
> Joo Pedro Machado de Sousa


Hello!

Has anybody sucsesfully imported in to mysql *.dbf file witch has MEMO
field(*.fpt, *.smt)?
I'm using ODBCDBE. When I import *.dbf without MEMO field ewrything is
OK. If I import *.dbf with MEMO field I get (Memory allocation error).
Any help is welcome.

LP, Dejan

Dejan,

> Has anybody sucsesfully imported in to mysql *.dbf file witch has MEMO
> field(*.fpt, *.smt)?
> I'm using ODBCDBE. When I import *.dbf without MEMO field ewrything is
> OK. If I import *.dbf with MEMO field I get (Memory allocation error).
> Any help is welcome.

I haven't tried it in mySQL, but I've done it in PostgreSQL - just set the
PG column type to 'text' and it works.

Regards,

Phil Ide

***************************************
* Xbase++ FAQ, Libraries and Sources: *
* goto: http://www.idep.org.uk/xbase  *
***************************************

I'll get to it on the 2nd Tuesday of next week.

"Dejan Stancevic" <stanac@softic.si> glsD:VKqBZBUzEHA.6380@S15147418...
>
> "Joo Pedro Machado de Sousa" <macsousa@maso.co pt> wrote in message 
> news:3jhu6vixs7em$.4zfqvjzu5xn7$.dlg@40tude.net...
>> Hi Leander
>>
>> What kind of problems?
>>
>> Very Best Regards
>>
>> Joo Pedro Machado de Sousa
>
>
> Hello!
>
> Has anybody sucsesfully imported in to mysql *.dbf file witch has MEMO
> field(*.fpt, *.smt)?
> I'm using ODBCDBE. When I import *.dbf without MEMO field ewrything is
> OK. If I import *.dbf with MEMO field I get (Memory allocation error).
> Any help is welcome.
>
> LP, Dejan
>

Dejan Stancevic

I have the same problem !

However,
I convert MEMO field's data into HEX ... then store the HEX string into
mySQL's BLOB field

Shum
www.mingyik.com


"Dejan Stancevic" <stanac@softic.si> glsD:VKqBZBUzEHA.6380@S15147418...
>
> "Joo Pedro Machado de Sousa" <macsousa@maso.co pt> wrote in message 
> news:3jhu6vixs7em$.4zfqvjzu5xn7$.dlg@40tude.net...
>> Hi Leander
>>
>> What kind of problems?
>>
>> Very Best Regards
>>
>> Joo Pedro Machado de Sousa
>
>
> Hello!
>
> Has anybody sucsesfully imported in to mysql *.dbf file witch has MEMO
> field(*.fpt, *.smt)?
> I'm using ODBCDBE. When I import *.dbf without MEMO field ewrything is
> OK. If I import *.dbf with MEMO field I get (Memory allocation error).
> Any help is welcome.
>
> LP, Dejan
>