Subject Re: [firebird-support] Import FoxPro .dbf data to FireBird .fdb? (Memo fields special case)
Author Carlos Guzmán Álvarez

>Is there any easy and quick way to import FoxPro .dbfs data into a FireBird .fdb?
Huummm .... using Visual Foxpro remote views for the Firebird
database and APPEND FROM should be easy.

You can check the Interbase Datapump too:

>The FoxPro .dbfs will contain lots of memo fields with unknown text lengths of clients correspondences, which include embedded carriage returns and line feeds.
>I am aware of varchar in FireBird but it still requires a length to be
>specified for the field, what type is there in FireBird to allow (well
>almost <g>) perpetual text content lengths.
Use a text blob (blob sub_type text)

Best regards

Carlos Guzmán Álvarez