FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour convert MySql to DBF
Posts: 1598
Joined: Fri Oct 07, 2005 05:56 PM
convert MySql to DBF
Posted: Wed Jul 24, 2019 09:46 AM

Dear Master,

I try to save all MySql tables to DBF but MySql use UTF8. The DBF columns will be bigger 3 times.
Example


I use oCn:SaveToDBF( cSql, cDbfFileName )

oRs:name Varchar 30
when I save to DBF
customer->name Charactor 90

How can I fix this issue?

Regards,

Dutch



FWH 2304 / xHarbour Simplex 1.2.3 / BCC73 / Pelles C / UEStudio

FWPPC 10.02 / Harbour for PPC (FTDN)

ADS V.9 / MySql / MariaDB

R&R 12 Infinity / Crystal Report XI R2

(Thailand)
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: convert MySql to DBF
Posted: Wed Jul 24, 2019 11:36 AM

You can't.
We need to fix this.
We'll let you know.

Meanwhile, you may please adopt this solution for the time being.

viewtopic.php?f=3t=37508

&

Regards



G. N. Rao.

Hyderabad, India
Posts: 1598
Joined: Fri Oct 07, 2005 05:56 PM
Re: convert MySql to DBF
Posted: Wed Jul 24, 2019 12:59 PM
Thank you so much, Master.
nageswaragunupudi wrote:You can't.
We need to fix this.
We'll let you know.

Meanwhile, you may please adopt this solution for the time being.

viewtopic.php?f=3&t=37508
Regards,

Dutch



FWH 2304 / xHarbour Simplex 1.2.3 / BCC73 / Pelles C / UEStudio

FWPPC 10.02 / Harbour for PPC (FTDN)

ADS V.9 / MySql / MariaDB

R&R 12 Infinity / Crystal Report XI R2

(Thailand)
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: convert MySql to DBF
Posted: Mon Jul 29, 2019 12:06 AM

Fixed in FWH 1907.

Regards



G. N. Rao.

Hyderabad, India
Posts: 1598
Joined: Fri Oct 07, 2005 05:56 PM
Re: convert MySql to DBF
Posted: Mon Jul 29, 2019 12:33 PM

Dear Master,

Thank you so much.
Dutch

Regards,

Dutch



FWH 2304 / xHarbour Simplex 1.2.3 / BCC73 / Pelles C / UEStudio

FWPPC 10.02 / Harbour for PPC (FTDN)

ADS V.9 / MySql / MariaDB

R&R 12 Infinity / Crystal Report XI R2

(Thailand)

Continue the discussion